Slicer/Filter by colour in Visual Chart

[KilJhard]

Hello,

Something I've been trying to find an answer to is if I creat a bar chart and assigned 3 colours based on a conditional format.  For instance, if below 333 the bar is to be green, between 334-666, amber and 667-1000 red is there a way that you can create a legend for those 3 colours and if you click on either one it will display those bars only.  So if I click on green all other bars a faded out (like when you normally click on something in a visual).

I thought this would be baked into the visuals but I've yet to find how to set this up.  I've tried creating a table with the colours assigned to a cell and using a slicer but that certainly did not work. lol.

[edhans]

Not directly. The colors aren't part of the report layer like that. What you could do:

1. Manually create buttons that were just those colors.
2. Create bookmarks to filter the data by each color.
3. Assign those bookmarks to the respective buttons

[KilJhard]

Morning @edhans thank you for your response.  

The buttons I'm creating, would these simulate the bar graph?  So the report I'm creating will be updated monthly based on the numbers from that month and the colours are based on whether there is low risk, medium risk and high risk.

I've already conditional formating for the bar graph so when next months data is added it'll adjust and apply the colour depeding on the range of the number such as if its below 333 it'll be green, if its between 334-666 amber and between 667 -1000 red.

I've attached an image to help with my terrible explaination. 😄