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 thi...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity 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,