Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
57 | |
37 | |
36 |
User | Count |
---|---|
85 | |
65 | |
60 | |
46 | |
45 |