Forum Discussion
Helper IKPI visual - Low is good
Microsoft EmployeeHi @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
Helper IHi v-huizhn-msft,
so you say that when "Low is Good" is set, goal is 13% and value is 10,9%, then distance is "+16,15%"? But this cannot be right, its mathematically wrong!
Distance between 10,9% is always less than 13% by 16,15%, so there has to be -. Similarly 15,1% is always higher than 13% by 16,15%, so there has to be +. Option between "Low is Good" and "High is Good" should affect just color and check/exclamation mark, not a math. sign.
I understand what you mean that when value is better than plan, there should be + and when value is worst than plan, there should be -. However minus sign doesnt have to be interpreted as negative, resp. bad. It can easily be positive, resp. good. And its even common practice in other BI tools for Low is Good KPIs. KPI Indicator works that way too.
I dont understand reference on Sean post, because in first part he just demonstrates, how to solve +/- issue by change color in "High is Good" mode, but finds out then there is issue with check/exclamation marks. In second part he shows that KPI Indicator custom visual works correctly. Basicly he confirms what I am saying all the time.
Best,
Jiri