Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
As you cansee, I want to create a report look like in the picture above.
The problem is that there are several set of buttons above and their interactions with metrics should be considered.
For example when I select dollor, outbound, and YTD, all the metrics should be calculated accordingly, and when I select euro, outbound, and MTD, it should present euro, outbound, and MTD metrics, and there are about 8 metrics in total.
I thought about bookmarks and field parameters but could not decide how to make it easily. Do you have a good solution that consider the switch about the conditons and metrics easily? Thank you.
Field Parameters are a good choice. You can use them for measure groups. You can also consider using Calculation Groups but those are more limited.