y-axis

[Klasovic7]

My problem is that on the y-axis only whole numbers should be displayed. If I set the decimal places to zero, a grid line with the value 1 is still displayed at 0.5.

[Klasovic7]

Hello @v-yanjiang-msft,

thank you for your answer.
However, I do not want decimal places to be displayed.
My chart is about the number of tickets and there are no 0.5 or 1.5 tickets. I want horizontal lines to be displayed only for integers.

[v-yanjiang-msft]

Hi @Klasovic7 ,

Do you set the option "value decimal places" to 0? If so, the value 0.5 will be displayed as 1, it's by design.

If you don't want to display the dicimals, a workaroud is to increase the Maximum number of Y-axis range.

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Klasovic7]

Hello @v-yanjiang-msft;

thank you also for this suggestion, however this does not work either because I cannot set a maximum because the number of tickets is different for each customer. The chart is filtered so that each customer can only see the number of tickets they have.
For example, one customer has 470 tickets, another only 2.

[v-yanjiang-msft]

Hi @Klasovic7 ,

I reproduced your problem, please check the visual format>Y-axis>Values>Value decimal places.

If the value is 0, replace it to 1 can solve the problem:

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.