Cascading filters in Filter Pane

KarthikKS — Tue, 16 May 2023 17:22:32 GMT

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

Re: Cascading filters in Filter Pane

Anonymous — Fri, 19 May 2023 07:10:20 GMT

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

topic Re: Cascading filters in Filter Pane in Developer

Cascading filters in Filter Pane

Re: Cascading filters in Filter Pane