Forum Discussion

JellyFish310's avatar
JellyFish310
Frequent Visitor
7 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
    7 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
    7 months ago

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

BhavinVyas3003's avatar
BhavinVyas3003
Icon for Super User rankSuper User
7 months ago

For matrix visuals, The column structure is generaly fixed.

The other way to handle this is by creating a dynamic index or rank for Criteria within each Group and Team. This index should update automatically whenever the data refreshes.You then use this index as the matrix column.