Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
aslam-ansari
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.

https://docs.google.com/spreadsheets/d/1a3JonDRfHtIzAlpWG1hQnNJ68c6d2vKe/edit?usp=sharing&ouid=11231... 

 

It would be fantastic if anyone could assist with this report direct query method.

 

1 REPLY 1
lbendlin
Super User
Super User

COALESCE(<your value>,"D")

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.