Forum Discussion
Hide labels if 0
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.
Super UserCan you post an example screenshot of what you're seeing?
And maybe some data?
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.
- KNP
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.