Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
53 | |
46 | |
15 | |
12 |