Forum Discussion
Change Bar Chart Colour based on slicer selection
Anonymous
I know how to get 3 different colors for 3 different categories but nor more than that :smileysad:
Basically you can use the Color Saturation Property of the Chart to define colors. Sample PBIX File is attached
Hello,
Alternatively, if the slicer is based on a table, you could add the hex codes of the colors you want to the table. Then set the data colors > Default color format to the column. This avoids the limit of 3 like the previous solution but does come with its own caveat. You can only have one slicer option chosen at a time.
Setting the Data Colors > Default Color to the Hexcode
Kudo CommanderI love this tip, BlueTeam1 . I noticed, though, that the setup doesn't work for the background color of the slicer that holds the values responsible for the color change. Bit of a bummer, but not the end of the world. Thanks for this!