Forum Discussion
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,
first chart keep the filter and third chart will filter based on first and second filter.
thank you
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
MaggieCommunity 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.
3 Replies
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.
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
MaggieCommunity 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.
