Skip to main content
Microsoft Idea

Power BI

Merged

Conditional formatting of data color on legend with Stacked or clustered column/bar Chart

Vote (34) Share
Cedric Fodouop Kamologne's profile image

Cedric Fodouop Kamologne on 13 Oct 2021 09:20:12

Currently, when you add a field for legend in stacked/clustered column or bar chart, you can't use conditional formatting for data colors. you can set them manually but it would be great to be able to use conditional formatting here, like that you can have predefine colors for stacks that you can map dynamically.

There may be a limitation when the conditional formatting will not return a color for a stack, in this case I suggest either having a default color or an error message indicating an invalid color value.

Compared to other dataviz tools, this point appears to be a limitation of Power BI and may be a barrier to adoption.

Regards