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 c...
Need Help
Show and Tell
Tips and Tricks
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: