Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
KarthikKS
Regular Visitor

Cascading filters in Filter Pane

Hello Everyone,

 

I've been so far using the slicers for this report but as a phase upgrade we thought to move the slicers to the filter pane, that's when we encountered the issue which we were able to achieve in slicer but not in Filter Pane.

 

I wanna achieve cascading filter between two dimensions (Country & Division) in filter pane, which are all connected only through the fact tables & applying bi-directional filter is also not possible here, because the model contains two fact tables connecting with the other two dimensions.

 

Attaching the sample data of how my data looks like.

Dimensions - Country & Division   and   Fact - Organization & Organization History (Audit / SCD 2) table.

 

My data looks like below :-

KarthikKS_2-1684256233757.png

 

 

Data Modelling :-

KarthikKS_3-1684256248988.png

 

Relationships :-

Dim Country & Org Fact (ID-CountryID)

Dim Division & Org Fact (ID-DivisionID)

Dim Country & Org Fact Hist (ID-CountryID)

Dim Division & Org Fact Hist (ID-DivisionID)

 

Warm Regards,

Karthik KS

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @KarthikKS,

In fact, current power bi use 'AND' logic to link different filters. So if you choose items on one filter, the other filter and visualizations which enabled interaction will be filter by current filter effects.

If you want to achieve some customize selection effect between these filters, you can try to break relationships between these table and write measure to use Dax formula to filter slicer item based on selection and use on ‘visual level filter’ to filter records.

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @KarthikKS,

In fact, current power bi use 'AND' logic to link different filters. So if you choose items on one filter, the other filter and visualizations which enabled interaction will be filter by current filter effects.

If you want to achieve some customize selection effect between these filters, you can try to break relationships between these table and write measure to use Dax formula to filter slicer item based on selection and use on ‘visual level filter’ to filter records.

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.