Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
andre_kroker
Frequent Visitor

2-category [clustered column chart] dynamic color formatting

Hi All(),


In the event of having just 1 category in the chart, it is perfectly possibile to conditional format the color.

However, I have a [clustered column chart] with 2 categories: "Numerador" and "Denominador". Is there a way where I can accomplish this: Format the "Numerador" color based on a specific DAX expression and "Denominador" on another DAX Expression?

It´s hard for me to believe Microsoft still haven´t got this done.

 

andre_kroker_0-1692814543770.png
Thanks!

2 REPLIES 2
Anonymous
Not applicable

Hi @andre_kroker 

Based on the current version, you can only use conditional formatting when you don't use legend. it is the best way to move the legend if you want to use the conditional formatting.

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Idrissshatila
Super User
Super User

Hello @andre_kroker ,

 

Here is a clustered column chart and I can see the fx that you could add an expression. Are you sure you're having the lastest version of power bi?

Idrissshatila_0-1692822779054.png

 

Idrissshatila_1-1692822870950.png

 

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors