Forum Discussion
Pie chart showing labels for zero values
Hello,
I am using a pie chart as shown below. For some reason, a value of 0.00 is being labeled by default when it should not be. The chart in question is displaying resource hours by category. This particular resource does not have any hours in this category at all. Not even a tiny fractional amount. It is also worth noting that there are several other categories with zero hours, and those are not being labeled. I only want to show labels for categories that have hours attributed to them. Is there a way I can fix this?
This screenshot shows what I am referring to:
Thank you!
7 Replies
- Greg_Deckler
Community Champion
Perhaps try doing a visual filter for the value of > 0?
Hey Greg,
Thank you for the response. I thought of trying to use a filter but that introduces a different problem. All of the visual level filters seem to be "frozen". I am unable to click the dropdowns or use the radio buttons to edit the filter. Additional searches have revealed that this must be because the numbers have already been aggregated. Unfortunately I don't have any ability to manipulate the source data I am recieving.
- Greg_Deckler
Ahhh, is this a live connection then (DirectQuery) versus import?
