Advanced Card: Conditional Formatting for Text Values

[StuartSmith]

Has anyone figured out how to get conditional formatting for the font colour of "Text" values on the "Advanced Card".  It has a "Conditions" option, but it only allows numerical values and I want Advanced Cards to have "Yes", "No" and "Everything Else", but the "Data Label" option doesnt have the "..." next to "colour".

Thanks,

Stu

[v-yiruan-msft]

Hi @StuartSmith ，

Base on my research, I can't find the proper option to set the conditional formatting for text field in Advanced Card. Is it possible to replace it with Power BI default Card visual? If yes, you can refer the following blog to achieve it.

Enhance the Card Visual in Power BI with Conditional Formatting

By the way, the text field is fact field in table or from the returned value based on a certain condition(for example: xxx>1000,"Yes"; if xxx<1000,"No" ; if xxx=0,"Everything Else")? Please some sample data(exclude sensitive data) and your desired result. Later we will check whether there is another way with advanced card to achieve it.

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[StuartSmith]

Hi, I am using the "Advanced Card" visual becuase it has the "Pre-Fix" & "Post-Fix" option, where as the standard card visual does'nt, I have previously used conditional formatting on the standard card visual, but was hoping there was a way on the Advanced Card.

Thanks

[StuartSmith]

For exampe data, basically its something like.. and the card should display "Yes" in "Green", "No" in "Red" and everything else in "Black".  

Access       Open

Door1        Yes

Door 2       No

Door 3       N/A

Door 4     

Hope that helps,

Thanks

[v-yiruan-msft · Accepted solution]

Hi @StuartSmith ,

I created a sample pbix file(see attachment) for you based on your sample data, please check whether that is what you want.

1. Create a measure to get status with numeric values

Measure = IF(MAX('Table'[Open])="Yes",1,IF(MAX('Table'[Open])="No",0,-1))

2. Create a advanced card (Data field: Open  Condition field: new created measure) and configure Conditions options in Format pane as below screenshot

Best Regards