Forum Discussion
Automating Column colors for each year
I currently use Clustered Column Chart to show data by a field called Inception Year. I select and set the colors for eacy year by Formating Columns and applying Series settings for each year and se...
Hi bdehning
It depends on how the column chart is configured. If a legend is used to split the values by year, automating it isn’t currently possible. Conditional formatting only works when no legend is applied to the column or combo chart. A workaround is to pre-assign values to future years by having them exist in the model even if your current data shows only up to the current and then use a measure that will not return blank for any of the year. Example:
Some value = 1