Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Formatting Traffic Light Indicator in Card

I am using a traffic light indicators UNICHAR(11044) in a card. Not sure how to do the color conditional formatting based on values. 
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We can set the condition format in the card format - Data label.

     

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

To use the conditional formatting based on values you need to create another measure that returns a number then based on that create your conditional formatting rule.

 

Conditional formatting =
SWITCH (
    TRUE ();
    SUM ( 'Table'[Column2] ) <= 100; "#605E5C";
    SUM ( 'Table'[Column2] ) <= 300; "#000000";
    "#F0E199"
)

This is just an example you can adjust as you need.

 

Regards,

MFelix