Card conditional formatting not working for <1 turn red

[siddrow]

 Hi

I have a card that is linked to an MS List and the column is set to number type. I have tried putting a conditional formatting on the card number to say if the number is <1 then turn text green and if the number is >=1 then turn red. I have some zeros in my MS list and they are showing on the card as red. How do I get the conditional formatting to work?

[v-yanjiang-msft · Accepted solution]

Hi @siddrow ,

Do you mean the Card visual like below? But card visual can only display one number.

I create a sample using a table visual, here're the steps:

1.Create a measure.

Measure = IF(MAX('Table'[Column])<1,"Green","Red")

2.In the visual formatting pane>Cell elements, turn on the Font color button.

Select the Field value in the Format style and select the measure in the field pane.

Get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@siddrow , You can use measure conditional formatting

Assume you have a measure number 

Switch(True() ,

[Number] < 1, "Green" , "Red"

)

PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

[siddrow]

Sorry not sure what you mean when you saw measure number. 

My cards are pulling the data from the queries, there are no measures attached to them at the moment. How would I add a measure to change the colour if <1 to green and =>1 to red but also show 0 instead of blank?