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!View all the Fabric Data Days sessions on demand. View schedule
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!