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 al...
Need Help
Tips and Tricks
HoangHugo's avatar
HoangHugo
Solution Specialist
4 years ago

Hi, you can, please refer model below

measue

   PBI = 

     var select_metric = SELECTVALUED (KPI)

      return

        SWITCH (select_metric,
                       "Metric 1", FORMAT (your formula for Metric 1, "General Number"),

                       "Metric 2", FORMAT (your formula for Metric 2, "Percent"),

                       "Metric 3", FORMAT (your formula for Metric 3, "Currency"),

                      "Metric 4", FORMAT (your formula for Metric 4, "General Number").

                      Blank ())

 

  • krist_pbi's avatar
    krist_pbi
    Helper I
    4 years ago

    Hey, thanks man, sorry I'm not that good in DAX yet, I kinda understand the formatting but my data model has different facts tables so that makes it harder to get it right

    I have this file with dummy data with the current data model I'm working with, maybe this can give you a better perspective of what I need https://1drv.ms/u/s!AqyfrLljieLpjwd9Hqd5_Fww-CA1?e=UgIM0X that is the onedrive link for the pbix file

    I appreciate your help!