Forum Discussion
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...
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 .
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.
Exactly all my Slicers are from Separate Dim tables rohit1991 .