Hide zero values in pie chart

[Anonymous]

Hi

How to hide the zero percentage values in pie chart lables using with measure or calculated column?

[vanessafvg · Accepted solution]

@Anonymous you can use the visual filters of the pie chart ie.

[tuoba]

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?  

[DataAlchemist]

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%

[tuoba]

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.

[Anonymous]

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.

[tuoba]

No idea how to resolve yet, please let me know if you have something new. Thanks