Trellis bar chart with different colours using matrix Chart

[Anonymous]

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

[V-lianl-msft]

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]

@V-lianl-msft 

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

See below,

[Anonymous]

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