Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe'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
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
Solved! Go to 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.
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 ;). |
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 ;). |
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 have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 35 | |
| 31 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 75 | |
| 72 | |
| 39 | |
| 35 | |
| 23 |