Forum Discussion

GanesaMoorthyGM's avatar
GanesaMoorthyGM
Helper 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 .

GanesaMoorthyGM's avatar
GanesaMoorthyGM
Helper II
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
Community Support
8 months ago

Hi GanesaMoorthyGM ,

Thank you for providing an update and confirming that the issue has been resolved. If you require any further assistance. Please feel free to let us know, we’re happy to help!


Thank you 
Chaithra E.