Forum Discussion

aslam-ansari's avatar
aslam-ansari
Frequent Visitor
3 years ago

Help with matrix visual

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.

https://docs.google.com/spreadsheets/d/1a3JonDRfHtIzAlpWG1hQnNJ68c6d2vKe/edit?usp=sharing&ouid=112315269167815576605&rtpof=true&sd=true 

 

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

 

 

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Hi aslam-ansari ,

     

    Try the following:

     

    • Create a disconnected table with the weeks
    • Add the following measure:
    Values =
VAR calculationvalue =
    CALCULATE (
        MIN ( 'Item'[Status] ),
        'Item'[Week] = SELECTEDVALUE ( Weeks[Week] )
    )
RETURN
    IF ( ISBLANK ( calculationvalue ), "D", calculationvalue )

     

    • Use the new table on the columns and the measure on the values result below and attach PBIX file:

    Top one is with the measure bottom one is you data raw: