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
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

    • jiri_siroky's avatar
      jiri_siroky
      Helper I
      9 years ago

      Hi v-huizhn-msft,

       

      yes, 15,1% is by 16,13% higher then 13%. So it should be +16,13%.

       

      In your explanation, how would it work when value would be 10,9%? It's at distance to goal by 16,13% (from 13%) as well. So distance would be -16,13% from both 10,9% and 15,1%. When "Goal" is hidden, only variation in KPI visual would be color and exclamation/check mark which doesnt seem righ.

       

      Other explanation - you know your goal (13%) and distance from goal (-16,15%). With these two informations, how would you ever be able to recognize if actual value is 10,9% or 15,1% 

       

      In Sean post, he shows how custom visual KPI Indicator works with these values and it works correctly IMHO. Unfortunately custom visuals are not suported for .ppt export and dont support number formattiing, so its not option for us. 

       

      Best,

      Jiri

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

        Hi @jiri_siroky,

        If goal is 13%, and you set the Color coding as "High is Good". If the distance is +16.15%(positive), you actual value is 15.1%. If the distance is -16.15%(negative), you actual value is 10.9%. Conversly, the result is opposite.

        In addition, the first of solution Sean posted is a KPI visual in Power BI desktop. The second part is custom visual.

        Thanks,
        Angelia