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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
Anonymous
Not applicable

Hide labels if 0

Hi all,

 

Is there a way to hide labels in a graph when the data is 0? Without removing the x axis months for example?

 

Thanks

1 ACCEPTED SOLUTION

I recreated your scenario.

If you turn your 0 into null you should no longer have the problem. It is often better to have these as null for calculation/performance reasons.

KNP_0-1638292165321.png

KNP_1-1638292317201.png

If you do this, you do need to remember to turn on the 'Show items with no data' option.

 

KNP_2-1638292383092.png

 

If changing 0's to null is not an option for you, you could mess with this formatting option to make values < 1 to have formatting the same colour as the background. You'd need to turn off the label background. I'm having a few issues getting this working at the moment. Not sure if it is a little buggy.

KNP_4-1638293487783.png

 

 

KNP_3-1638293407045.png

 

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
xOIEmaj

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
image
fabric-SUbadge
Proud to be a Super User!

View solution in original post

3 REPLIES 3
KNP
Super User
Super User

Can you post an example screenshot of what you're seeing?

And maybe some data?

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
xOIEmaj

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
image
fabric-SUbadge
Proud to be a Super User!
Anonymous
Not applicable

Rm666652_0-1638261837423.png

Its just a simple graph, I want to hide lables with 0 and keep the rest. Hiding values that are 0 doesnt work because it also removes the dates, which I want to keep.

 

I recreated your scenario.

If you turn your 0 into null you should no longer have the problem. It is often better to have these as null for calculation/performance reasons.

KNP_0-1638292165321.png

KNP_1-1638292317201.png

If you do this, you do need to remember to turn on the 'Show items with no data' option.

 

KNP_2-1638292383092.png

 

If changing 0's to null is not an option for you, you could mess with this formatting option to make values < 1 to have formatting the same colour as the background. You'd need to turn off the label background. I'm having a few issues getting this working at the moment. Not sure if it is a little buggy.

KNP_4-1638293487783.png

 

 

KNP_3-1638293407045.png

 

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
xOIEmaj

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
image
fabric-SUbadge
Proud to be a Super User!

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.