Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I created a bar chart with a limit line, but each bar is from a different base that I did the data modeling.
I am not finding the option to make a conditional color that if it is greater than the boundary line turns red, if it is less than the boundary line turns green.
can you help me ?
You do not have the option of conditional formatting in colors.
Solved! Go to Solution.
Hey @Anonymous ,
this is simply not possible, as Power BI does not allow to change the fill color if the color is used for identifying the single "member" inside a cluster. The fill color will be automatically applied to the members inside a cluster, based on the color in the legend (the single member). It's not possible to overwrite the fill color using conditional formatting.
Maybe, you will create an idea on ideas.powerbi.com
Regards,
Tom
Hi,
If the above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!
Hey @Anonymous ,
this is simply not possible, as Power BI does not allow to change the fill color if the color is used for identifying the single "member" inside a cluster. The fill color will be automatically applied to the members inside a cluster, based on the color in the legend (the single member). It's not possible to overwrite the fill color using conditional formatting.
Maybe, you will create an idea on ideas.powerbi.com
Regards,
Tom
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 11 | |
| 10 | |
| 9 | |
| 4 |
| User | Count |
|---|---|
| 32 | |
| 25 | |
| 20 | |
| 19 | |
| 19 |