Forum Discussion
Slicer/Filter by colour in Visual Chart
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 ...
Not directly. The colors aren't part of the report layer like that. What you could do:
- Manually create buttons that were just those colors.
- Create bookmarks to filter the data by each color.
- Assign those bookmarks to the respective buttons
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. 😄