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.
If you do this, you do need to remember to turn on the 'Show items with no data' option.
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.
| 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 ;). |
| 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. |
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 ;). |
| 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. |
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.
If you do this, you do need to remember to turn on the 'Show items with no data' option.
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.
| 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 ;). |
| 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. |
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
