Cascading filters

[Anu]

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.

[BrianJ]

@Anu,

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.

Updating slicers & bi-directional relationships

Hi all, I’m very new here so I’m sorry if this question has been raised and answered before. I’ve been using Power Bi professionally for maybe 6 months. In my role in my organisation, we typically need a lot of slicers at the top of the page to enable our end users to drill down to their specific data. These slicers are always built from Look-up tables but slicers often come from different (unrelated) look-up tables. Personally, I like to see a slicer update to only show the possible values a…

I hope this is helpful.

• Brian

[EnterpriseDNA]

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!