Chart filter base on measure

[Anonymous]

Hi,

I hope you can assist me,

I have a table with two hierarchies, country and PG(R&G, BEANS, Capsules). In addition, I have a pie chart showing the PG's .

Right now, when I select a country on the table, the pie chart filters the country and the pg, While I need it to filter only the country.

Do you have any idea of I does it is?

Thank you,

[v-stephen-msft]

Hi @Anonymous ,

It is recommended that you create a slicer with only countries to filter. You filter directly from the table, which is actually the same as filtering countries in a slicer with a hierarchy of countries and PGs.

If you want to filter in the table without affecting the pie chart, you must also filter out the country, change your interaction settings.

Change how visuals interact in a report - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[olgad]

Hi, basically you click on the cell with 327 and those are being shown to you, because those 327 lie in Romania R&G , go up in your matrix and use the paralell arrows (the third ones) to go down to country level without R&G and then click on Romania

Alternatively you can add a country slicer as well to filter it this way.