Cascading filters in Filter Pane

[KarthikKS]

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 :-

Data Modelling :-

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

[v-shex-msft · Accepted solution]

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