KPI Visual Colour Coding

[Anonymous]

Is it possible to change the colour of the KPI visual depending on how close it is to the target? My current visual shows green/ red if over/ under, but we would like to show it as orange if we are within 10% of the target. Is this possible?

[Anonymous]

Hi @Anonymous,

AFAIK, current KPI visual support conditional color formatting. You can choose the 'color coding' menu and click on the 'fx' icon to choose a measure to use on color formatting.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Anonymous , thanks for the reply.

I am aware of this colour coding format. My current KPI visuals are in the direction of high is bad in the colour coding fomat. So anything over the target on the KPI is shown as red, under shown as green.

However, I am wanting to show anything that is over the target but is within 10% of the target as orange. Is this possible? My data figure and target's are not in %. Is there some formula I can add that specifies that if my figure is more than 10% over the target then text be red, if it's less than 10% over put it as orange?

Thanks

[Anonymous]

Hi @Anonymous,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to design visuals with particular color formatting.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , How have used conditional formatting that?

One option can color measure 

Switch(true(),

[KPI] < 0,  "Red" ,

[KPI] <.10 , "Orange" , // 10 if nor %

"Green"

)

You can use this in conditional formatting using field value.