Is there a way to have conditional formatting option for a Clustered column chart in Power BI?

[efti18]

Hello everyone,

I’m currently working on a report in Power BI and I would like to apply conditional formatting to a Clustered Column Chart. My goal is to visually differentiate the columns based on their values—for example, using a gradient color scale where lower values are depicted in red, medium values in yellow, and higher values in green.

However, I’ve noticed that the standard options for conditional formatting don’t seem to be available for this type of chart (probablty because I use legend).

Here are my specific questions:

1. Is there a built-in feature in Power BI that allows for conditional formatting in clustered column charts?
2. If not, are there any workarounds or alternative methods to achieve similar results?
3. Are there any custom visuals or DAX measures that I can use to implement this feature?

   Any advice or insights would be greatly appreciated!

   Thank you in advance for your help!

[pankajnamekar25 · Accepted solution]

Hello @efti18 

You can try

Power BI does not natively support conditional formatting on Clustered Column Charts when a Legend is used

You can Remove the Legend
If you remove the Legend field, you’ll see the “Data colors” → “fx” option to apply conditional formatting based on value or rules.

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[MattiaFratello · Accepted solution]

Hi @efti18,

If you don't use a legend you can use fx, please check below:

Please make sure to not use the legend, otherwise fx won't be available.

If I answered your question please mark my answer as solution.

[rajendraongole1]

Hi @efti18 - You can remove the legend and instead encode color directly via DAX

Create a color measure based on value ranges

Color By Value =
SWITCH(TRUE(),
[YourMeasure] < 50, "#FF0000", // Red
[YourMeasure] < 80, "#FFFF00", // Yellow
"#00FF00" // Green
)

Then in the Data colors section of the visual formatting pane, go to the fx icon → choose “Format by field value” → select the Color By Value measure.

[MattiaFratello · Accepted solution]

Hi @efti18,

If you don't use a legend you can use fx, please check below:

Please make sure to not use the legend, otherwise fx won't be available.

If I answered your question please mark my answer as solution.

[efti18 · Accepted solution]

Thank you for your answer. I noticed that I cannot have more than one value on Y axis to have this option available. Aren't there any workarounds?

[MattiaFratello]

Hi @efti18, I'm afraid not. You may want to check in the custom visuals.

[efti18]

Can you recommend a custom visualization?

[pankajnamekar25 · Accepted solution]

Hello @efti18 

You can try

Power BI does not natively support conditional formatting on Clustered Column Charts when a Legend is used

You can Remove the Legend
If you remove the Legend field, you’ll see the “Data colors” → “fx” option to apply conditional formatting based on value or rules.

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.