Forum Discussion

yashwant101's avatar
yashwant101
Helper III
2 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
Uzi2019
Community Champion
2 years ago

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!