Clustered Column Chart Axis Data Color

[hnguyen76]

Good morning!

I'm wondering if this is possible within a clustered column chart. I have a clustered column chart that has months split into buckets and pulled into the AXIS of a clustered column chart. Within the VALUE field, if I have one field, I'm able to choose my required colors as seen in the first image below:

However, when I add an additional column into the VALUE field the colors are gone:


Is there a way to make both VALUES within the axis to achieve the same data colors? For instance, anything in the "Up to 3 months" would be green and anything within the "Greater than 1 year" would be red. 

Thanks in advanced!

[Anonymous]

Hi @hnguyen76 ,

You can refer to following link to use advanced color formatting to achieve your requirement:

Tips and tricks for color formatting in Power BI

Notice: above feature not available if you enable legend field.

Regards,

Xiaoxin Sheng

[hnguyen76]

@Anonymous

Hi. I've read that article multiple times and it doesn't mention anything about multi-value clustered charts. 

[Anonymous]

Hi @hnguyen76 ,

Advanced color control require you not use legend field and multiple value fields, then you can use conditional color formatting on that value field.

Please submit or vote ideas about improve advanced color formatting features.

Regards,

Xiaoxin Sheng