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 .

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
9 months ago

Hii GanesaMoorthyGM 

 

Power BI slicers do not automatically cascade unless the data model supports it.
To make Country >> LocationCode responsive, ensure they come from separate dimension tables and correct single-direction relationships exist.
Use DimCountry and DimLocation tables in slicers  not fields from the fact table.
Once the model is corrected, selecting “Qatar” will only show Qatar’s LocationCodes.

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

Exactly all my Slicers are from Separate Dim tables rohit1991 .