The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
User | Count |
---|---|
65 | |
61 | |
60 | |
53 | |
30 |
User | Count |
---|---|
181 | |
88 | |
71 | |
48 | |
46 |