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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi GanesaMoorthyGM,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like the slicers are not automatically cascading based on actual data availability in fact_sales. As Ashish_Mathur, FBergamaschi, Shahid12523 and MasonMA have rresponded to your query, kindly go through their responses and check if your issue can be resolved.

 

I would also take a moment to thank Ashish_Mathur, FBergamaschi, Shahid12523 and MasonMA, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.