How to do conditional formatting in KPI when using Live Connection

[Anonymous]

Hey,

As we have conditional formatting in tables, can we do similar in KPI?

I have to show a color bar using a meausre, when it's >= 100% then Green, when it's <100% then Red.

I tried using table for the bar, but it doesn't show background color of the meausre until n unless i add a column to the table. 

And i can't create a blank column as i am using Live connection. 

Anything that i can try? 

thanks in advance 🙂 

[Anonymous · Accepted solution]

I found a solution. 

You can import visual Advance card from market place. 

Pull you measure into it and go to Conditions into column formatting. 

I had two conditions, to show Green color bar for when value is >=100%  and Red for the rest. 

So, i chose no of conditions = 2

and turned on Data lables

And similarly for Red.

Now turn on the fill condition and it's done.