Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sarithaallot
Contributor III
Contributor III

New Multi KPI color change based on Measure value

Hi Team 

I am Trying to give color to my multi Kpi based on my value.Means if i have negative value then it should show red colour if i have positive value it should show green value.

This is my formula for variance.i want to change the variance kpi color based on my value.In this picture variance -694 should show red color because it is having negative values.

sum({1<Country=p(Country),Type=p(Type)>}[Latest estimate])
-
sum({1<Country=p(Country),Type=p(Type)>}Budget)

 

Screenshot (31).png

 

 

Thanks

 

2 Replies
Anil_Babu_Samineni

Answer is "No"

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
humansoft
Partner - Contributor III
Partner - Contributor III

@sarithaallot @Anil_Babu_Samineni 

These days it is possible:

Variance is below zero and it is redVariance is below zero and it is red

You have to:

  • add Measure (Master item) for Variance
  • define Segment colors for Variance (Master item, Measure)
  • select Conditional value color for Variance measure on your's Multi KPI object

Master items, Measure - Segment colorsMaster items, Measure - Segment colors

 

Defined Segment colors for Variance measureDefined Segment colors for Variance measure

 

Multi KPI - Conditional value colorMulti KPI - Conditional value color