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.

2 Replies

  • MFelix's avatar
    MFelix
    Super 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

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    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.