Forum Discussion
Helper IIICard conditional formatting not working for <1 turn red
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?
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
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/1682539
siddrowSorry 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?
- v-yanjiang-msft
Community Support
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
