topic How to do conditional formatting in KPI when using Live Connection in Custom Visuals Development Discussion

How to do conditional formatting in KPI when using Live Connection

Anonymous — Mon, 10 Feb 2020 08:51:56 GMT

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 — Fri, 14 Feb 2020 08:31:30 GMT

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.