Forum Discussion

GanesaMoorthyGM's avatar
GanesaMoorthyGM
Icon for Helper II rankHelper II
1 year ago
Solved

How to Make FY and LocationCode Slicers Dynamic Based on Selected Country in Power BI

Hi Community, I have a fact_sales table along with dimension tables for Country, Location Code, Month, and FY in my data model. And this is my data modelling Here’s what I want to achieve:...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Write this measure

    Total = sum(Data[sales])

    Drag this measure in the filter pane of the FY slicer and set the criteria to Not blank.

    Hope this helps.

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
1 year ago

Use cascading slicers:

 

1.Set relationships (Country → Location → fact_sales, FiscalYear → fact_sales) to Both cross filter direction.

2.Add slicers: Country, Fiscal Year, Location.

3.Enable Edit Interactions so slicers filter each other.

 

Result: Selecting a Country filters Fiscal Years, and selecting Country + FY filters Location codes.

 

If relationships get messy, use calculated slicer tables with CALCULATETABLE + ALLSELECTED.