cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UncleLewis
Super User
Super User

Custom Number Format Line Chart Y Axis

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

1 ACCEPTED SOLUTION
MahyarTF
Memorable Member
Memorable Member

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 

MahyarTF_0-1669542656356.png

Appreciate your Kudos and please mark it as a solution

Mahyartf

View solution in original post

2 REPLIES 2
PaulDBrown
Super User
Super User

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






MahyarTF
Memorable Member
Memorable Member

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 

MahyarTF_0-1669542656356.png

Appreciate your Kudos and please mark it as a solution

Mahyartf

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.