Forum Discussion
Solved
Create Submission Report
I am trying to create a visual that shows missing or unfinished entries. I have a table like this where there is only 1 entry for each Project/Month pair
| Project | Date | Finalized |
| ProjectA | 1/1/2020 | 1 |
| ProjectA | 2/1/2020 | 1 |
| ProjectB | 2/1/2020 | 1 |
| ProjectC | 2/1/2020 | 1 |
| ProjectA | 3/1/2020 | 0 |
| ProjectB | 3/1/2020 | 1 |
| ProjectC | 3/1/2020 | 1 |
| ProjectA | 4/1/2020 | 1 |
| ProjectC | 4/1/2020 | 1 |
| ProjectD | 4/1/2020 | 1 |
| ProjectA | 5/1/2020 | 0 |
| ProjectB | 5/1/2020 | 1 |
| ProjectC | 5/1/2020 | 1 |
| ProjectD | 5/1/2020 | 1 |
| ProjectA | 6/1/2020 | 1 |
And I want to show something like this: Where I want to show
Red = “missing”
Yellow = “Not Finalized”
Green = “Finalized”
I have a Calendar table linked and I have tried this with a matrix using the Finalized field With Green>= 1
Yellow ==0, and Red = IsBlank
But all I ever get is red, it never shows anything as 0 Value. I am assuming this is becaue it is using Sum of Finalized and adding with a blank doesn't work.
Is there a way to do this?
Thanks
- DAX for you:Coloring table =var current_status = SUM('Table'[Finalized])returnSWITCH(TRUE();ISBLANK(current_status);-1;current_status = 0;0;current_status > 0;1)
2 Replies
- DAX for you:Coloring table =var current_status = SUM('Table'[Finalized])returnSWITCH(TRUE();ISBLANK(current_status);-1;current_status = 0;0;current_status > 0;1)
Thanks, This worked for me, I just had to change to commas instead of semicolons.
