Chart filter base on measure

Question

Hi,I hope you can assist me,&nbsp;I have a table with two hierarchies, country and PG(R&amp;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?&nbsp;Thank you,&nbsp;&nbsp;&nbsp;

olgad · Answer

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.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
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
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Chart filter base on measure

2 Replies

Related content

Previous Year Measure for Line Chart

Filter required for Multiple measures for combo chart

Dynamic measure filtering

Filter by Rank measure

Using measure as a filter