Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Help with Matrix visual
06-08-2023
06:46 AM
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.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023
04:06 PM
COALESCE(<your value>,"D")

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
06-23-2025 03:26 PM | |||
05-22-2025 04:22 AM | |||
06-13-2025 01:37 AM | |||
08-28-2024 08:47 AM | |||
05-16-2025 06:35 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |