Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

cascade filter

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, fir...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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's avatar
Greg_Deckler
Community Champion
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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 ?