Column chart not showing all Y axis values

[Hussein_charif]

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 only the values 0, 20 and 40, i need to resize the column chart to almost double the size to show 0,10,20,30,40,50 which i dont want to resize.
is there another way to be able to show the Y axis values with an interval of 10°C?

[Uzi2019]

Hi @Hussein_charif 

Unfortunetly no. You cant change or customized the interval of Y axis. There is no way of doing it.

you can check other blog also.

https://community.fabric.microsoft.com/t5/Desktop/y-axis-interval/m-p/3592671#M1180893

I hope I answered your question!

[Uzi2019 · Accepted solution]

Hi @Hussein_charif 

You can only control the Min and Max of Y axis. But not interval .

I hope I answered your question!

[Hussein_charif]

hi @Uzi2019 , 

seems like it yeah, thank you

[bhanu_gautam]

@Hussein_charif ,

Select the Column Chart: Click on your column chart to select it.
Open the Format Pane: In the Visualizations pane, click on the paint roller icon to open the Format pane.
Expand the Y-Axis Options: Find the Y-Axis section and expand it.
Set the Interval: Look for the option to set the interval (it might be labeled as "Interval" or "Major units"). Set this value to 10.
This will ensure that the Y axis shows values at intervals of 10°C (0, 10, 20, 30, 40, 50) without needing to resize the chart.

[Hussein_charif]

hello, there is no interval option, only range, values and title

[bhanu_gautam]

Create 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.