Forum Discussion
Hide zero values in pie chart
Hi
How to hide the zero percentage values in pie chart lables using with measure or calculated column?
Anonymous you can use the visual filters of the pie chart ie.
6 Replies
Anonymous you can use the visual filters of the pie chart ie.
Hi, thanks your post.
After I did that in visual level filter, when the correspoding category value is below 1, the whole pie chart disappear, but I want only the category with zero value to be hiding. Any idea on why is this happened?
It sounds like the values you want to hide aren't actually 0.00% - they're probably something like 0.000000000009% but are being presented as 0.00%?
The solution suggested by vanessa will work but you'll need to allow for the fact that percentages are actually decimal numbers.
1 = 100%
0.5 = 50%
0.25 = 25% and so on.
So you'd need to apply a visual level filter to show only those greater than 0.0001%? (Maybe). However, this may result in the total being less than 100%
