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 has a SWITCH() statement to calculate the YTD/MTD depending on what is selected in that slicer (see example in screenshot  below for calculating Net Sales)

  • Ex. All of 2021 + 2022 through April is selected on the Date slicer, and MTD is selected in the Time Selection slicer. The measures then filter to include April 2022 data only.  Toggle the YTD/MTD slicer to show YTD and all of the measures will then show 2022 through April only. If a user then includes June of 2022 on the Date slicer, the YTD will include the data available through June for the entire year, and the MTD will include only June 2022.

Desired State: a Field Parameter that users can toggle for YTD/MTD that changes EVERY measure on the entire canvas for all visuals WITHOUT using SWITCH() statements.


 

Need Help

2 Replies

    • 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]) )