Forum Discussion

GanesaMoorthyGM's avatar
GanesaMoorthyGM
Icon for Helper II rankHelper II
9 months ago
Solved

Cascading / Dynamic Filter Response help

Hi everyone, I need help configuring my Power BI slicers so they behave responsively based on user selections. I have the following filters: FiscalYear Month Country Location Code Wh...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • GanesaMoorthyGM's avatar
    GanesaMoorthyGM
    9 months ago

    Guys I solved by using a measure like:

    Cascading filter = INT ( NOT ISEMPTY(fact_sales))

    And add this is in all slicers visual lvl filter for all slicers eg:FiscalYear,Month,Country,Location_Code



    Now it is acting fine.

    Thank you for your response v-echaithra , rohit1991 .

v-echaithra's avatar
v-echaithra
Icon for Community Support rankCommunity Support
9 months ago

Hi GanesaMoorthyGM ,

To make cascading slicers work in the new Power BI slicer experience, ensure that each slicer field comes from a dimension table with a single-direction relationship into the fact table, and remove any relationships that bypass the fact table. When the fact table becomes the only path between Country, Location, Month, and FiscalYear, Power BI automatically shows only the valid values for the selections.

 

Open Model view.

Ensure relationships are exactly like this:

DimFiscalYear > Fact

DimMonth > Fact

DimCountry > Fact

DimLocation > Fact

 

Make sure Relationship direction = single (one-way), no bidirectional filters, no direct relationship between DimCountry and DimLocation. Also verify the fact table contains the Country + Location combinations that you expect.

Hope this helps.
Thank you.