Multilevel matrix

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

Need Help

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