Forum Discussion
GanesaMoorthyGM
Helper III
Helper IIIHow 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:...
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.
Ashish_Mathur
Super User
Super UserHi,
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.