Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi I'd appreciate your help with the following
I'm trying to create a simple scorecard matrix like this one
Weeks in columns, each KPI in rows with its own data format, conditional formatting based on each individual goal etc.
When I try to do that using the matrix it returns the following
You see that the KPIs are not in rows, actually the table gets bigger since now for each week num, it will show the 3 metrics at the same time, then it goes to the following week and so on...
Is there a way I could accomplish this? I have this file uploaded in onedrive with fake data that shows my data model and the options I have tried so far
https://1drv.ms/u/s!AqyfrLljieLpjwgJw5NPBoxLmTef?e=pf1n0W
Thanks!
Solved! Go to Solution.
@krist_pbi ,See if the attached file can help. You can have the additional conditions for conditional formatting
@amitchandakhey thanks a lot! you actually save lots of hours trying to figure this out, thanks!
@krist_pbi ,See if the attached file can help. You can have the additional conditions for conditional formatting
User | Count |
---|---|
94 | |
79 | |
76 | |
65 | |
60 |
User | Count |
---|---|
106 | |
99 | |
77 | |
63 | |
61 |