Forum Discussion
Clustered Column Chart Axis Data Color
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!
3 Replies
- AnonymousNot applicable
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
- hnguyen76Resolver II
Anonymous
Hi. I've read that article multiple times and it doesn't mention anything about multi-value clustered charts.
- AnonymousNot applicable
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