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 IIThank you. This is very basic data.
| Learner Name | Status | Overall Status |
| Name 1 | Active-In Progress | Incomplete |
| Name 2 | Completed | Completed |
| Name 3 | Active-Not Started | Incomplete |
| Name 4 | Completed | Completed |
| Name 5 | Active-In Progress | Incomplete |
| Name 6 | Completed | Completed |
| Name 7 | Completed | Completed |
| Name 8 | Completed | Completed |
| Name 9 | Pending | Pending |
I am not using a slicer though as it doesnt perform the same when we selected as a table. The table keeps the total, then breaks down depending on which Overall Status selected.
saud968
Memorable Member
Memorable Memberdownload this file https://drive.google.com/file/d/123vIFR6hhwKut44QnQ_JzoyO4mnEqaU7/view?usp=drivesdk
and review it is working as expected.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!