Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 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's avatar
    Anonymous
    6 years ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.