Putting column data in rows for table

[GentleGrid]

I have a dim table with columns and values like this:

I am trying to get a visualization table that looks like this:

When the user selects a project with the slicer, the table should change to the project that has been selected.

Is there a standard way to handle this in Power BI? I know I could unpivot the dim table, but this would obviously screw up the data relationships.

[ryan_mayu · Accepted solution]

@GentleGrid 

here is a workaround for you

create a new table

column 1 sort by sort column

then create a measure

Measure =

SWITCH(SELECTEDVALUE('Table (2)'[Column1]),"Project",max('Table'[name]),"Size",max('Table'[size]),"Owner",max('Table'[owner]),"Weight",max('Table'[weight]),"Dimension",max('Table'[dimensions]))

pls see the attachment below

[GentleGrid]

That worked, thanks a lot!

[ryan_mayu]

you are welcome