Custom Number Format Line Chart Y Axis

[UncleLewis]

Hi all,

Is it possible to get a custom number format on the Y Axis?
I formatted for thousands, but now zero shows as 0.0K, I would prefer a "-" for zero.

Thanks,

-w

[PaulDBrown]

Line/clustered column/bar charts require a numerical value for the values to be displayed. If you change 0 to "-" it will become text

[MahyarTF · Accepted solution]

Hi,

Not sure if there is any solution, where the Y Axis format is as a number(decimal), but the "-" is char type.

if you don't want to show the 0.0 value, then you could change the Minimum Range of the Y-Axis and start it > 0 

Appreciate your Kudos and please mark it as a solution