Forum Discussion
Hussein_charif
Helper V
Helper VColumn chart not showing all Y axis values
hi, i have a quick question i have a column chart that shows average temperature. the maximum value is 50, which i set in my maximum values in the Y axis format pane. the thing is, the Y axis shows ...
You can only control the Min and Max of Y axis. But not interval .
I hope I answered your question!
Hussein_charifHelper V
Helper Vhello, there is no interval option, only range, values and title
bhanu_gautam
Super User
Super UserCreate a New Measure:
Go to the "Modeling" tab.
Click on "New Measure".
Enter a DAX formula to round your temperature values to the nearest 10.
RoundedTemperature = ROUND([YourTemperatureColumn], 10)
Use the Custom Measure in Your Chart:
Replace the original temperature values in your chart with the new RoundedTemperature measure.
Adjust the Y-Axis Settings:
Set the minimum value to 0 and the maximum value to 50.
Ensure the axis displays the values correctly.