Forum Discussion

ITManuel's avatar
ITManuel
Responsive Resident
3 years ago
Solved

Conditional formatting clustered column chart -- multiple values

Hi,

 

there are previous threads about this matter, I'm wondering if there is some update to it in the meantime?

 

I would like to use conditional formatting of the colors of the bars in a clustered bar chart with multiple column values, however the icon for conditional formatting disappears in the formatting ribbon when more than 1 value is present. If only 1 value is present the icon returns.

 

1 value

 

 

 

 

 

 

 

 

2 values:

 

 

 

 

 

 

 

 

Previous thread: 

https://community.powerbi.com/t5/Desktop/Contitional-format-clustered-column-chart-with-multiple-column/m-p/1123642#M513245

 

Best regards

  • Probably not the most elegant way to go about this, but you could split each measure into 2 (for example, for +ve or -ve values) and then choose the colour for each

     

2 Replies