Forum Discussion
How to do conditional formatting in KPI when using Live Connection
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 usi...
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.
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.