Forum Discussion

krist_pbi's avatar
krist_pbi
Helper I
4 years ago
Solved

Design scorecard matrix

Hi everyone,

 

I need help with creating a scorecard in PBI with this structure, as you can see each row is a different metric with it's own value, format, goal, conditional formatting, etc. but all of them are sharing a horitzontal axis for the weeks.

 

These are some of the challenges I've faced so far:

 

  • Matrix Visual cannot display weeks in columns for different metrics without affecting the structure
  • I tried creating a table single column for each KPI value and Name, then formatted it depending if it's percentage, currency, etc. BUT you can't apply individual targets/goals to each KPI if you're using only one column so it doesn't work
  • I could create each metric individually, then grouping together all of them in one object so it can replicate a single scorecard visual BUT then each metric has it's own navigation bar/scroll bar at the bottom, so you need to move one by one to look across previous or future weeks, not really intuitive or easy to use right?
  • The Power KPI Matrix (custom visual) doesn't let you put the weeks in columns as the example in the screenshot, and personally I don't really like it, but if you know there is another visual to do the same, that'll work

Here is a onedrive link to download a dummy pbix with the data models and ideas https://1drv.ms/u/s!AqyfrLljieLpjwd9Hqd5_Fww-CA1?e=UgIM0X

 

Any idea that could potentially solve this is more than welcome, thanks!

 

 

5 Replies