Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Unpivot table visual

Hey guys! I wanted to know, is there a way to pivot a table visual? I have a table that looks like this: Is there a way to change it IN the visual in order to get something like this? ...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Anonymous 
You can do unpivot from power query.
Steps to follow:
1) select your column to unpivot

2) go to transform tab >  unpivot > unpivot selected columns

 

3) it will look like this attribute - value columns

 

4) save and close

Note: If you dont want other columns so can remove other columns from Power query.

if my post helps please give kudos and accept it as a solution!
Thanks

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    But what do I do with the calculated columns?

    • Uzi2019's avatar
      Uzi2019
      Community Champion
      2 years ago

      Hi Anonymous 
      I have not asked you to create calculated column. just jo the above steps to pivot your columns. 
      I am saying if you dont wanted any columns apart from pivot so you can remove it.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Im sorry, the idea here is to pivot ALL of them. The ones that come in the excel file + the ones I calculated. 

         

        Unpivoting only the ones in the file does not resolve my issue.