Forum Discussion
Helper IIChange colour within Clustered Column Chart based on Slicer
Helper III know why, sorry. The slicer doesnt break down the data in the chart when you click on it so I used a table.
So I have to use a slicer to get the colours but then it just does:
Memorable MemberHave you tried this
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!
- Whibley92
Yes I did, it just keeps them blue. I'm very new to Power BI so its probably really easy to do. Any advice on where I may be going wrong?
Color Measure =SWITCH(SELECTEDVALUE('Learning Item Status report'[Status Overall]),"Completed", "#5DDA7E", --Green"Incomplete", "#F43232", -- Red"Pending", "#F08439" -- Amber)- saud968
No problem, we all have been in your position. I will request you to create an Excel sheet with some data remove the sensitive info and share that file. As it is difficult to understand what is going wrong when you are trying.
- Whibley92
Thank 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.