Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Field Parameters to Toggle Entire Dashboard Between Date Ranges

Current State: we have a slicer that toggles all measures on a dashboard to show either TYD or MTD for the date range selected - the date range uses a date hierarchy for year and month. Every measure...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Amit,
The problem is that I basically need a MTD/YTD slicer for all measures on the entire canvas using field parameters instead of embedding SWITCH() statements into every measure. The screenshot is just showing one measure for this dashboard, however, there are 6 KPIs that would need to change based on the field MTD/YTD parameter selection across the entire dashboard. Is this even possible? 

I did create two measures to get the last day of the month selected and one for the last day of the year selected and put those into field parameters however it's not filtering the data any further than the Date Hierarchy slicer does already. 

YTD= YEAR(LASTDATE('Date'[Date]) )

MTD = MONTH(LASTDATE('Date'[Date]) )