​
Hey everyone,
I am building a report where I have one metric measured for 10 categories. I have several charts on different pages listing that breakdown and for consistent formatting I want a single place to declare the colors - which aren't the theme colours, but custom ones.
I've put the hex values in a dimension table describing the categories, with the idea to reuse them in any visual. However, as those categories are displayed against a time dimension, they require a legend/colouring of each series separately and conditional formatting doesn't appear as an option.
I found multiple posts discussing the same challenge but most of them are at least two years old - so I wanted to ask again.
Atm, my only way forward will probably be declaring the 10 categories as measures, and then a measure for the conditional formatting, probably using something like Selectedmeasure..