cancel
Showing results for 
Search instead for 
Did you mean: 
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
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.