Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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)
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.
@Anonymous , Create two measures MTD and YTD and use that in field parameters
Field Parameters- One solution for Measure Dimension slicer: https://youtu.be/lqF3Wa1FllE?t=70
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]) )
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
97 | |
93 | |
87 | |
68 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |