Matrix style fiscal year grid

Hi DJ_Jamba ,

Have you solved your problem?
If not, you can try this way, here is my sample data ( Note: Power BI can't identify Amber, so I changed it into Blue 😞

You can use this DAX to create a measure:

Measure = 
IF(
    MAX('Progress Reporting'[RAG Status])="",
    "grey",
    MAX('Progress Reporting'[RAG Status])
)

Follow the diagram below to set up:

The final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.