Dynamic Color for Multi-Bar Bar Chart

[yashwant101]

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

[Anonymous · Accepted solution]

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:

[Uzi2019]

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!