Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi!
I don't know why, but the conditional formatting to change colors depending on a switch factor doesn't work on specific visuals, such as the Card (New) or any bar graph.
Furthermore, the Card (New) visual the conditional formatting affects the background or the shadow, but not the callout value itself.
In relation to the bar graphs, I can't even use gradient or rules, so the conditional function itself is broken.
But, for some metrics, it does work, for example, the normal Card or the KPI visual.
I've created a Power BI file from 0 to see if it has something to do with other relationships, but it does not.
The graphics I've tried
The switch function used
Table used
Any help would be much appreciated.
Thanks!
Solved! Go to Solution.
Hi @Woncarc
The new card visual still is preview so expect for bugs. I use it but with caution. For example, with small multiples, I can't make it work for the first item but can for the rest and I return the field value using tables and matrices, the values are as expected. For the bar chart, it requires a column to be added to Y-axis, you can create a dumy column using a calclulated column or in another table with a non-blank value. Below is a sample dummy table with an unnamed column containg a single row with a value of "". Add this to your viz.
dummy = {""}
Please see the attached pbix.
It did work! Thank you very much!
Hi @Woncarc
The new card visual still is preview so expect for bugs. I use it but with caution. For example, with small multiples, I can't make it work for the first item but can for the rest and I return the field value using tables and matrices, the values are as expected. For the bar chart, it requires a column to be added to Y-axis, you can create a dumy column using a calclulated column or in another table with a non-blank value. Below is a sample dummy table with an unnamed column containg a single row with a value of "". Add this to your viz.
dummy = {""}
Please see the attached pbix.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.