Forum Discussion
Whibley92
Helper II
Helper IIChange colour within Clustered Column Chart based on Slicer
How do I change the colours dependent on slicer selection. I have 3 categories in my slicer - I would like each one to be a different colour when selected, ie Completed = green, Incomplete = red, Pen...
Whibley92Helper II
Helper III'm not using the slicer
saud968
Memorable Member
Memorable MemberThese statuses are columns or measures. Also, the fx option you have to review other options and also did you try the custom column Dax
Below is another measure you can try
Color Measure =
SWITCH(
SELECTEDVALUE('SlicerTable'[Category]),
"Completed", "#00FF00", --Green
"Incomplete", "#FF0000", -- Red
"Pending", "#FFA500" -- Amber
)
Apply to Chart:
Go to the "Format" tab of your chart.
Select "Data colors" -> "fx"
Select the newly created "Color Measure."
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!