Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Weeks with amounts in columns

Hi,   I'm currently working on a dataset with an another layout that I'm used to. Normaly I've got the weeks sorted in the rows, as below;   But for now, the weeks are spread over the colu...
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Select the first 2 columns, right click and click on "Unpivot Other Columns".  You will now see the Table as you see in image 1.

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ，

     

    Transform data.

    Select column [Brand] and column [Model] -> right click and click Unpivot Other Columns -> Close and apply.

    Attach the PBIX file for reference. Hope it helps.

     

    Best Regards,
    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ，

 

Transform data.

Select column [Brand] and column [Model] -> right click and click Unpivot Other Columns -> Close and apply.

Attach the PBIX file for reference. Hope it helps.

 

Best Regards,
Community Support Team_Gao

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data