Forum Discussion
Prevent charts from changing colour based on filter
I have a device energy table linked to a devices table with a relationship to a site table. I have a report page full of visuals about my devices, with a slicer for selecting a site. Only 1 site can ever be selected at the same time. I want the visuals to always use the first colours in my theme, but when I change the selected site, it changes to later colours in the theme. I assume this is because a colour is assigned to each device regardless of site, rather than applying colours after the site has been selected.
How can I prevent this colour changing?
Thank you so much in advance!!!!
Hi isaacrushworth ,
I think that yo ucan accomplish this if you created a custom calculated column that is a specific color and then use that color field for whenever a site is selected. You would probably have to use that color in the conditional formatting to make it "stick".
1 Reply
- collinq
Super User
Hi isaacrushworth ,
I think that yo ucan accomplish this if you created a custom calculated column that is a specific color and then use that color field for whenever a site is selected. You would probably have to use that color in the conditional formatting to make it "stick".