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 
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.

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi Anonymous 
    Unfortunetly No, What ever DAX columns you are creating Cant be available in Power query.🙄

    So that's not possibe what you are trying to achieved in Power query. Basically Pivot colums not possible in your case.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Alright, and going back to the original question:

       

      Is there a way to pivot the Table´s visual??? 

      If theres a way to do that, then I can solve my issue

  • audreygerred's avatar
    audreygerred
    Super User
    2 years ago

    The columns that you are adding in as calculated columns, can you add them in in Power Query instead of adding them in as calculated columns in DAX?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Noo, I cannot 😞

      • audreygerred's avatar
        audreygerred
        Super User
        2 years ago

        If you don't mind me asking, what are the calculated columns? If you share the DAX maybe we can try to move them.