Forum Discussion

GentleGrid's avatar
GentleGrid
New Member
2 years ago
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 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.

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    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
     

     

     

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    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