Forum Discussion

jiri_siroky's avatar
jiri_siroky
Helper I
9 years ago

KPI visual - Low is good

Hello to all ,   I need to setup some KPI visuals for KPIs which lower is better (for example MIR - marketing investment ration). I found in Format option to set Lower is good, but when I need show...
Need Help
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

I think it is a matter of perspective. You are -16.33% away from your goal of 13%. Yes lower is better but you are still 16.33% "below" your goal. Whether it should work that way is another question but I can see arguments both ways.

jiri_siroky's avatar
jiri_siroky
Helper I
9 years ago

Hey Greg_Deckler and Sean,

 

Thanks for you replies.

 

At first, I was thinking its matter of perspective as you said, but more I think about it I am sure its misleading and mathematically wrong how it works now. Quickly I can write two reasons:

 

  • you are effectively above your goal (13%) by 16,15% - I cannot find case when I would interpret this as "we are below goal". Trust me, I tried to defend this way of interpretation to myself (which would be more comfortable that solving this problem on community as I am not english native speaker :) ) , but I wasnt successful. Or can you find way how to interpret this?
  • you can hide "Goal" - in this case you get red 15.1% witch exclamation mark and below it you can see (-16.15%) which will be surely intepret as "you are bellow goal by 16.15%" (in this case consumer of report would think goal is 18,01%...). Yes, U dont have to hide "Goal", however when Goal isnt effectively goal, but its value from past day/week/month/year you have to, because there is no way, how change this label. 

 

ad KPI Indicator custom visuals - yes, here it works corretly (according to my opinion), but as I wrote above, custom visuals operate on library which doesnt currently support number formatting (according to one of developers of PBI custom visuals - (not this one)), which is block for us :(

 

Best & thx,

Jiri

 

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi jiri_siroky,

    You have understand how it works, right? Goals - when set to On, the visual displays the goal and the distance from the goal as a percentage. If you set the high is good in Color coding, it your value is high the goal, it will show positive. Otherwise, the result is opposite. For your result, you must set "low is good" in Color coding. 16.15%=(15.1%(value)-13%(goal))/13%(goal). 

    Please feel free to ask if you have any other issue. If you have resolved it, please mark the helpful reply as answer, more people will benefit it.

    Thanks,
    Angelia

    • jiri_siroky's avatar
      jiri_siroky
      Helper I
      9 years ago

      Hi v-huizhn-msft,

       

      yeah, I get it, but problem is when I set "Low is good" and value is 15,1% and goal is 13%, visual shows me distance as "-16,13%", however result should be "+16,13%" (as you write) - I explained it above.

       

      So I think it's a bug.

       

      Jiri

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi jiri_siroky,

        It's not a bug. Please see the Sean posted. When you set low is god. The value is better as smaller(13% is better than 15.1%), so there is 16.13% differance to goal, so the result is negative. Wish this explaination is clear.

        Best Regards,
        Angelia