Forum Discussion
Solved
Putting column data in rows for table
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...
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
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
That worked, thanks a lot!
you are welcome
