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...
Hey! You can use automatic category colors instead of setting a color per year manually.
In your clustered column chart, remove the custom series color overrides and let the visual use the default color palette (Format > Data colors > Reset to default / turn off “Show all”). Then each new Inception Year (2027, 2028, etc.) will automatically get the next color with no yearly maintenance.
If later you need controlled logic, you can switch to conditional formatting with a DAX color measure ... but first step is to stop hardcoding colors per year.
Best Regards!