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

     

     

     

     

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