Now my matrix visual looks like this: I placed status in the value field and the same status column in the row field. I used conditional formatting to color the background and also used green color on the blank value and 'D'.
However, I would like the visual to appear like this.
The idea is simple. The D is the available item. D should appear after or before A, B, or C on the chart depending on the date. Some item statuses have only D, thus I can't filter them out.
It would be fantastic if anyone could assist with this report direct query method.
COALESCE(<your value>,"D")