Visualize filtered horizontal data vertical

[gvlado]

Dear PBI colleagues
I can't find the way to do the following

Want to from horizontal table get a vertical report (list of data) for filtered column (Name)

It should look similar like

The point is not to lose Source table because I need it for calculations (measures)

Actually it will be kind of catalogue of the names – when I chose name I will get the rest of data in vertical table.

[gvlado]

Wow, what a simple solution
Now I recognized Switch in options
Thanks a lot - you earned a coffee

[amitchandak · Accepted solution]

@gvlado , In a matrix visual put # on the column, No row, and put name, location, size, group, etc as a measure

and then use option - Switch values to row /Show values on row