Cascading filters

Can we create cascading filters in Power BI like that in SSRS.
Meaning, the result of 1st filter used to filter the 2nd filter ,which filters 3rd one and so on.


Yes, it’s definitely doable. I use this technique regularly in my reports, though it often requires some level of denormalization of the dimension tables. The other way to accomplish this is through the use of bidirectional relationships, though that is definitely NOT a recommended approach. Please see the thread below for more information on this issue, including an excellent article on the perils of bidirectional relationships.

I hope this is helpful.

  • Brian

Hi @Anu, we’ve noticed that no response has been received from you since January 23, 2020. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!