Forum Discussion

soderqvistn's avatar
soderqvistn
Helper I
1 year ago
Solved

Multilevel matrix

hi,

 

Is it possible to create a matrix like this? Clean with multiple expansions?

 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi soderqvistn ,

    Thanks for rohit1991 and danextian reply.

    You can try the following steps and here is sample data

     

    First Level Second Level Category Values Third Level
    First Second A VALUES Third
    First Second A VALUES Third1
    First Second B VALUES Third
    First Second B VALUES Third1
    First Second C   Third
    First Second C   Third1
    First Second D   Third
    First Second D   Third1
    First Second E   Third
    First Second E   Third1
    First Second F 55 Third
    First Second F 88 Third1
    First Second G   Third
    First Second G   Third1
    First Second G   Third

    Create a matrix

    Create a mesure

    Icons = 
IF(
    SELECTEDVALUE('Table'[Category]) = "G",
    "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='40' stroke='Green' stroke-width='4' fill='green' /> </svg>"
)

    Change the mesure data category to Image URL

    Apply the measure to icon

    Final output

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

     

     

3 Replies

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Assuming the second and third are row fields, they will have to be in in their own hierarchy and will be in another row.

  • rohit1991's avatar
    rohit1991
    Super User
    1 year ago

    Hi,

     

    1. Use a Matrix Visual: Add hierarchical fields for rows (e.g., First → Second). Values will populate as columns.

    2. Add Conditional Formatting: Use Icons (like green circles) for indicators under your values column. Go to Format > Conditional Formatting > Icons.

    3. Set Expand/Collapse: The Matrix visual supports expandable and collapsible rows by default.

    Result: Clean, hierarchical, expandable matrix with visual indicators.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi soderqvistn ,

    Thanks for rohit1991 and danextian reply.

    You can try the following steps and here is sample data

     

    First Level Second Level Category Values Third Level
    First Second A VALUES Third
    First Second A VALUES Third1
    First Second B VALUES Third
    First Second B VALUES Third1
    First Second C   Third
    First Second C   Third1
    First Second D   Third
    First Second D   Third1
    First Second E   Third
    First Second E   Third1
    First Second F 55 Third
    First Second F 88 Third1
    First Second G   Third
    First Second G   Third1
    First Second G   Third

    Create a matrix

    Create a mesure

    Icons = 
IF(
    SELECTEDVALUE('Table'[Category]) = "G",
    "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='40' stroke='Green' stroke-width='4' fill='green' /> </svg>"
)

    Change the mesure data category to Image URL

    Apply the measure to icon

    Final output

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly