cascade filter

[Anonymous]

hi all,

i am referencing my data to a folder that updated daily.

i want my report to interact first chart to filter my second and third chart. then when i select any bar on second chart,

first chart keep the filter and third chart will filter based on first and second filter. 

thank you 

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

If the first visual is a slicer, your requirement could be achieved.

But if the first visual is other visuals, when you click on the second or third visual, the first visual will change according to the interactions among these tables.

It is a limitation in Power BI currently.

There is a pbix which i use slicer as the first visual to achieve your requirement.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

So, I believe you will want to use Edit Interactions to make your 2nd chart NOT filter your first chart. Then you should be able to filter your first chart and would then hold down the Ctrl key to select the item in the 2nd chart.

[Anonymous]

thank you for the suggestion but it seems like i cannot select any bar in my chart when holding CTRL key. do this feature need to be enable first and where can i enable it ?