How to remove 0 values from a stacked bar chart

[mickeydjw]

I have a stacked bar chart in my report sitting next to a pie chart.  On the Y axis, I've got company names.  X axis is times they're tagged in a ticket.  The pie chart is ticket categories.  When I click a specific category in the pie chart, the rest of the visuals adjust, but company names that don't have any tags in that category.  How do I remove the companies with 0 so that the chart is easier to read?

[mickeydjw · Accepted solution]

PBI doesn't do it out of the box.  I had to use a custom visual.

https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104381230

[dilumd]

HI @mickeydjw

I suppose, you can use page level filters under visualizations menu to filter out zeros.

[mickeydjw]

That doesn't change it.  They still show up.