Forum Discussion
Dynamic Color for Multi-Bar Bar Chart
Hi all,
I have a use case where I have 2 different categories for each x axis value in a bar chart:
Is there a way to keep different color combination for Bangaluru and a different one for Chennai.
Is it possible to do it
Hi yashwant101 ,
I agree with what Uzi2019 said!
But I can give you a workaround.
Here is my sample data:Then I use these DAXs to create two measures:
Bangaluru = SUMX(FILTER('Table', LEFT('Table'[Name], 9) = "Bangaluru"), 'Table'[Value])Chennai = SUMX(FILTER('Table', LEFT('Table'[Name], 7) = "Chennai"), 'Table'[Value])Then create the Clustered Column Chart:
2 Replies
Hi yashwant101
Unfortunetly , No . you cant change the color of Bangaluru and Chennai.there is so such option availabe under column format setting.
you can only change the color of you both metrix Transit and inventory.
apart from it there is no such option available.
I hope I answered your question!
Hi yashwant101 ,
I agree with what Uzi2019 said!
But I can give you a workaround.
Here is my sample data:Then I use these DAXs to create two measures:
Bangaluru = SUMX(FILTER('Table', LEFT('Table'[Name], 9) = "Bangaluru"), 'Table'[Value])Chennai = SUMX(FILTER('Table', LEFT('Table'[Name], 7) = "Chennai"), 'Table'[Value])Then create the Clustered Column Chart:
