Ability to visualize the table by grouping by the first column

[RoksanaSZ]

Hello,

I have a some example table I would like it to be visualized in some required way.

Example table:

Type	Producent	Grade	Color	Parameter1	Parameter2	Parameter3
Car	Nissan	A	BLACK	A	B	S
Car	Nissan	A	BLACK	B	B	D
Car	Mercedes	A	BLUE	S	A	S
Car	Mercedes	A	GREEN	D	B	S
Car	Ford	B	RED	S	S	S
Car	Ford	B	YELLOW	S	D	A
Car	Ford	C	BLACK	S	S	A
Car	Ford	C	RED	A	S	B
Car	BMW	B	GREEN	A	S	H
Car	BMW	B	RED	B	B	A
Car	BMW	D	GREEN	F	F	G
Truck	Scania	C	RED	G	G	S
Truck	Scania	S	YELLOW	S	H	S
Truck	Man	C	BLACK	B	A	D
Truck	Man	C	BLACK	F	G	S
Truck	Man	S	BLACK	G	S	S
Truck	DAF	A	BLUE	H	S	D
Truck	DAF	A	GREEN	A	D	S
Truck	DAF	B	RED	W	S	D
Truck	DAF	B	GREEN	A	S	S
Motor	Suzuki	S	RED	B	D	S
Motor	Suzuki	D	GREEN	F	S	B
Motor	Suzuki	A	RED	G	S	F
Motor	Kawasaki	D	YELLOW	S	B	S
Motor	Kawasaki	S	BLACK	S	F	B
Motor	Kawasaki	S	BLACK	D	S	F
Motor	Yamaha	A	YELLOW	S	B	S
Motor	Yamaha	C	BLACK	S	F	S
Motor	Yamaha	B	BLACK	B	S	B
Motor	Honda	S	BLUE	F	S	B
Motor	Honda	D	GREEN	S	B	B
Motor	Honda	A	RED	S	B	S

I need it to be visualized in a way that groups the rows by the first column.

An example of the required display:

Example of another required view:

Unfortunately, the view of the example will obviously change, due to slicers for the user on all columns which eliminates the stiff layout.

I have already tried using matrix without stepped, but it does not come out as it should. Is anyone able to tell if it is possible to get this using matrix, table in PowerBi?

Thank you in advance for your reply and help 🙂

[parry2k · Accepted solution]

@RoksanaSZ you need to unpivot your data :

Transform Data -> Select nonparameter columns -> Right Click -> Unpivot other columns.

It will add 2 columns, attribute, and value, and rename as you see fit. Close and apply.

In matrix visual, use columns on the rows, attribute on the columns, and value on the values well. change the aggregation to min and max and that should work.