Forum Discussion

soderqvistn's avatar
soderqvistn
Icon for Helper I rankHelper 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

     

     

     

     

rohit1991's avatar
rohit1991
Icon for Super User rankSuper 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.