Hi,
By default the chart axis range is dynamically created using the minimum value and maximum value preset in the SQLQuery response.
However you can change this minimum and maximum value of a range sector for numeric columns.
By following below steps you can achieve this .
- Hover on the 3 dots which is present beside the Filters and you will get a dropdown in that select properties .
![image](https://forum.helicalinsight.com/uploads/default/original/2X/e/e3928b9cc481a81cc5c3f52ea9fc59d60e5f9761.png)
2.Now here click on Axis and you will see something like below
![image](https://forum.helicalinsight.com/uploads/default/original/2X/5/508e6e0dda880b4a0a3d15c1ac9c17e2ec816c22.png)
- Here if you select a numeric column in the Axis then you will get two options called ‘Max value’ and ‘Min value’
![image](https://forum.helicalinsight.com/uploads/default/original/2X/d/d8a3fc1076b0b961dc4d024137eaaf38bbe8536e.png)
In this fields you can define the range you want to the axis to be in between.
After making changes click on Apply button.
Thank you,
Helical Insight.