Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |