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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
agd50
Advocate III
Advocate III

How to get rid of zeroes on a chart

How to make it so it won't show a bar if it's value is zero?

Regards,
Andrew

agd50_0-1668581360941.png

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @agd50 

 

Do you mean don't show a data label?  The image you provided isn't showing a column for the 0 values.

 

To hide the 0's, apply a custom format string 0;0;; to the values column

 

custf.png

 

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @agd50 

 

Do you mean don't show a data label?  The image you provided isn't showing a column for the 0 values.

 

To hide the 0's, apply a custom format string 0;0;; to the values column

 

custf.png

 

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.