Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
UncleLewis
Helper V
Helper V

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
Community Champion
Community Champion

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.