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")

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)