Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Transpose in visualization alone

Hi All,   I would like to have Column header to be displayed in First Column and its values to be displayed in second column.     We can do transpose in Edit Queries but i want to change m...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ,

     

    Then you need first create a table ,and put all the column headers into one column,such as below:

     

    Then you need a measure as below:

     

     

    Measure =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Table (4)'[Header] ) = "Address", SELECTEDVALUE ( 'Table (2)'[Address] ),
    SELECTEDVALUE ( 'Table (4)'[Header] ) = "Amount", SELECTEDVALUE ( 'Table (2)'[Amount] ),
    SELECTEDVALUE ( 'Table (4)'[Header] ) = "Country", SELECTEDVALUE ( 'Table (2)'[Country] ),
    SELECTEDVALUE ( 'Table (4)'[Header] ) = "Gender", SELECTEDVALUE ( 'Table (2)'[Gender] )
)

     

    Finally in the new table ,put column and measure into a matrix as below:

    And you will see:

     

     

    For the related .pbix file,pls click here.

     

    Best Regards,
    Kelly

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ，

 

Go to "edit queries">select all columns>"Transform">"Unpivot columns":

 

Then choose "Use first row as headers":

 

Choose "close and apply",then you will see :

 

 

Best Regards,
Kelly

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-kelly-msft 

 

Thanks for your response but do we have any other way to do it without using Query editor and Edit Queries section. i.e., in front end itself or just creating a measure or calculated column?

 

Thanks

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Then you need first create a table ,and put all the column headers into one column,such as below:

     

    Then you need a measure as below:

     

     

    Measure =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Table (4)'[Header] ) = "Address", SELECTEDVALUE ( 'Table (2)'[Address] ),
    SELECTEDVALUE ( 'Table (4)'[Header] ) = "Amount", SELECTEDVALUE ( 'Table (2)'[Amount] ),
    SELECTEDVALUE ( 'Table (4)'[Header] ) = "Country", SELECTEDVALUE ( 'Table (2)'[Country] ),
    SELECTEDVALUE ( 'Table (4)'[Header] ) = "Gender", SELECTEDVALUE ( 'Table (2)'[Gender] )
)

     

    Finally in the new table ,put column and measure into a matrix as below:

    And you will see:

     

     

    For the related .pbix file,pls click here.

     

    Best Regards,
    Kelly

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-kelly-msft ,

       

      Let us assume out of these 4 column we have 1 as a measure then how to give that measure value?

       

      Thanks