Forum Discussion
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.
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.
