Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hello,
I am having trouble with conditionally formatting columns in a bar chart while maintaining a default color.
In the below chart I set the default color to dark red and added a line of conditional formatting to format to a lighter shade of red if another measure for that month returned blank.
As you can see, it formats correctly and the legend shows a red dot for the data series. Here is the formatting page:
And this makes sense to me - I set the default color to dark red, then add formatting if a condition is met.
I created that a few months ago. However now, I am trying to add a new chart using the same format but when I attempt to apply the same formatting, it does not maintain the dark red color. (I copied and pasted the previous graph and re-did the formatting.) It resets the default color to blue, and does not remember the dark red.
At this point if I modify the formatting on the previous graphs I made a few months ago, I cannot get the original formatting back and have to quit without saving.
I have tried using a color measure:
@AlainDelhaise , I think when you line clustered bar, it does not change the legend based on conditional formatting. It does that for pie and for bar it does not show a legend.
Hello @amitchandak, I am not looking to change the legend based on conditional formatting, I understand that is not supported, but it appears as though somehow a few months ago I could set the default color for the bars and then add conditional formatting on top, and now I cannot.
See the first image I posted, it both has a correct legend color and conditional formatting on the bars.
@AlainDelhaise , I tried all three options(Gradient, rule, field), not able to get the first one. May be an issue in the new release. check and report an issue, if needed: https://community.powerbi.com/t5/Issues/idb-p/Issues
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.
| User | Count |
|---|---|
| 79 | |
| 48 | |
| 36 | |
| 31 | |
| 29 |