Forum Discussion
Whibley92
Helper II
2 years agoChange 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...
saud968
Memorable Member
2 years agoYou can go to the format pane, then go to columns click on fx, and then set rules accordingly.
Further, you can also create a custom column
Color = SWITCH(
MyTable[Status],
"completed", "green",
"incomplete", "red",
"pending", "amber",
"unknown" // Default color for any other status
)
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
Whibley92
Helper II
2 years agoIts just making them all Orange