Use Donut chart instead of slicer

[lucie_rabochova]

Hello,

I'm using donut chart instead of slicer to filtering another column chart, both on the same page, see first printscreen.

If I click on blue part of donut to filter values, I want to see only red column and not the others on axis X.  Axis X is not dynamic in this case and showing names of the columns not included in the selection. The result should be like second printscreen. Thank you for your ideas.

First print screen:

Second print screen:

[danextian]

Hi  @lucie_rabochova

Did you make the measure used in the column chart return 0 if the value is blank? Then what you're seeing is expected.

In the image below Total Revenue test returns zero when the value is blank. 0 Values are not removed. It's different from blanks and nulls

The image below doesn't force 0 to appear when value is blank so NA is not visible in the column chart

From the filter pane, filter the column chart to [Measure nanme] is not 0.

[Vijay_Chethan]

You can achive this by going to format tab, then edit interaction of your pie chart to bar chart
change it to this:

if this helps, please mark as solution

[lucie_raboch]

It helps, thank you

How can I mark as Solution?

[Vijay_Chethan]

1. Find the reply that you want to mark as the solution.
2. Click on the "Accept as Solution" button located at the bottom of the reply.

[lucie_raboch]

Cannot see it, its probably not enabled here