Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Trellis bar chart with different colours using matrix Chart

Hi,

I have a below view that I need to show different colours for category field. (Matrix Chart)

Furniture-Red,

Office Supplies - Green,

Technology - Blue

Can anyone help me in achieving this requirement.

A quick help would be much appreciated

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous ,

     

    Try using  conditional formatting to change the color of the Bars.

     

    ( from the dropdown ( in my case it is sum of empID ) select the column you want to change, go to Data bars ->advance controls and select the color of your choice.

     

     

    Thanks,

    Tejaswi

     

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago
    Hi Anonymous ,
     
    There isn't any available way to achieve your requirements. You may submit an idea viahttps://ideas.powerbi.com/forums/265200-power-bi 
    See if this can solve some of your needs
    Measure = IF(MAX(Sheet9[category])="B","#33FF4C",IF(MAX(Sheet9[category])="A","#FF3633",IF(MAX(Sheet9[category])="C","#3933FF")))
    Use this measure in field vaule of background color
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      V-lianl-msft 

      When I use the calculation it just changed the background colour not the bar colours.

      See below,