Forum Discussion

JellyFish310's avatar
JellyFish310
Frequent Visitor
8 months ago
Solved

Visual "Matrix" with data in cells

Looking for some help. I have data that looks like this: Group Org Criteria Status Group 1 Team 1 101 R Group 1 Team 1 102 Y Group 1 Team 2 103 G Group 1 Team 3 104 G ...
Need Help
  • danextian's avatar
    danextian
    8 months ago

    Hi JellyFish310 

     

    Add a column that ranks your criteria within their own group and org. Add another column to repeat an invisible character based on those rank numbers - this will be used as the column header.

    Index Within Group Org = 
RANKX (
    FILTER (
        'Table',
        'Table'[Group] = EARLIER ( 'Table'[Group] )
            && 'Table'[Org] = EARLIER ( 'Table'[Org] )
    ),
    'Table'[Criteria],
    ,
    ASC,
    DENSE
)

------------------

Invisible Index = 
REPT ( UNICHAR ( 8203 ), 'Table'[Index Within Group Org] )

     

     

    Please see the attached pbix.

  • danextian's avatar
    danextian
    8 months ago

    the index/rank approach will put the criteria into individual cells. there is a pbix attached in my first response.

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
8 months ago

Hii JellyFish310 

 

Power BI does not support a matrix with a variable number of columns per row.The recommended approach is to keep the data in long format and use a Table visual with a DAX measure that concatenates criteria horizontally per Group/Team. Conditional formatting can be embedded in the measure (or via SVG) to reflect status. This solution works with slicers and avoids unsupported matrix behavior.

  • JellyFish310's avatar
    JellyFish310
    Frequent Visitor
    8 months ago

    Thanks, that's what I was expecting.


    I know how to concatenate the data in a measure, do have any resources on how to conditional format within that measure (the non-SVG way)?