cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Hide zero values in pie chart

Hi

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Hide zero values in pie chart

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

Proud a to be a Datanaut!
6 REPLIES 6
Super Contributor

## Re: Hide zero values in pie chart

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

Proud a to be a Datanaut!
Frequent Visitor

## Re: Hide zero values in pie chart

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?

Visitor

## Re: Hide zero values in pie chart

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%

Frequent Visitor

## Re: Hide zero values in pie chart

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.

Frequent Visitor

## Re: Hide zero values in pie chart

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.

Frequent Visitor

## Re: Hide zero values in pie chart

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

Announcements

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 366 members 4,034 guests
Recent signins: