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.

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

Another approach is to simply concatenate your criteria

Concatenated criteria = 
CONCATENATEX (
    'Table',
    'Table'[Criteria],
    " ",
    CALCULATE ( SELECTEDVALUE ( 'Table'[Criteria] ) )
)

 

JellyFish310's avatar
JellyFish310
Frequent Visitor
8 months ago

Thanks for your response. I understand how to do a simple concatenation to list the "criteria numbers" in one measure.

 

The kicker is that i absolutely need the conditional formatting (preferably the background) based on the "Criteria Status."

 

I doubt with the concat, or rank, method this is possible?

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    8 months ago

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