Forum Discussion
Set color in clustered column chart
Hi!
I have created a tooltip report and linked it to a column in another report (main report). This works fine and when i hoover over different products in the main report i get more detailed information about the product from the tooltip report. When i hoover over different products the columns in my clustered column charts in my tooltip report changes color for every new product in all charts i have in the tooltip report and i dont want that to happen. Instead i would like to set one color for the net sales column in my clustered column chart, another color for order column in my clustered column chart in the tooltip report. I could of course do that manually for all products in all charts in the tooltip report but it,s to much different products. Is it possible to force one color for the column in each clustered column report in the tooltip report regardless of which product i hoover over?
Can't you just use conditional formatting and hardcode a color into a measure?