Forum Discussion
Hide zero values in pie chart
- 8 years ago
Anonymous you can use the visual filters of the pie chart ie.
Thanks you reply.
But the problem here is, say I have three columns for value A, B, C, and fourth column for date, I put A, B, C in pie chart as values, and date in slicer as value. I want pie chart display only those percentage of category with value greater than 0 when I selected corresponding date in slicer, i.e. at some date, A might be zero, then only percentage of B and C will be on pie chart.
However when I add A, B, C to visual level filter and set to show items only when they are grater than 0, as long as one of them are zero, the whole chart disappear , but I want only the category to be hiding, not the whole thing.
I have the same problem... My whole chart dissapears when I do that. But I have so many zero values, so there labels are really distracting, so they really have to go... the only problem is I don't know how.
- tuoba7 years agoFrequent Visitor
No idea how to resolve yet, please let me know if you have something new. Thanks