Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Help with Matrix visual

Screenshot 2023-06-08 112346.png

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.

Screenshot 2023-06-08 101227.png
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.


Super User
Super User

COALESCE(<your value>,"D")

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors