Automating Column colors for each year

Thankyou, amitchandak, cengizhanarslan, RicardoTraNa , danextian, Thejeswar, and Praful_Potphode for your responses.

Hi bdehning,

Based on our understanding, when a field is placed in the Legend of a clustered column chart, Power BI automatically controls the series colours. In this configuration, the “fx” Field Value conditional formatting option is not available. 

As per our research, there is no official documentation confirming that legend-based conditional formatting for column charts is being restored. Therefore, we should consider the current behaviour as the supported design.

As noted by danextian , conditional formatting does not apply when a Legend controls the series. Additionally, as suggested by RicardoTraNa , the correct long term approach is to remove manual colour overrides and allow Power BI to utilise the default theme palette.

Additionally, please refer to the links below:
Apply Conditional Table Formatting in Power BI - Power BI | Microsoft Learn
Customize Power BI Visualization Titles - Power BI | Microsoft Learn
Conditional formatting in Power BI visuals - Power BI | Microsoft Learn
Tips and Tricks for Formatting in Reports - Power BI | Microsoft Learn

We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.