Forum Discussion
Solved
Matrix style fiscal year grid
Hello Community! My left eyebrow is flickering a lot over this 😂 I know there must be several ways to achieve this but I'm looking for the most optimal way 😁 I have: - A calendar table - ...
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.
lbendlin
Super User
Super UserCOALESCE should be able to help you. But in general to report on things that are not there you need to use disconnected tables and cross joins.