Forum Discussion
Helper Vhow to unpivot table with multiple columns
Hi Gurus,
I have a requirement to unpivot a table with multiple columns, not sure how would I go about it and would ended up giving me incorrect results. below is the image of my tabel, any help is highlty appriciated.
@amalrio, you should be able to select every year and unpivot in this case
https://radacad.com/pivot-and-unpivot-with-power-bi
Video : https://www.youtube.com/watch?v=2HjkBtxSM0g
4 Replies
- amitchandak
Super User
@amalrio, you should be able to select every year and unpivot in this case
https://radacad.com/pivot-and-unpivot-with-power-bi
Video : https://www.youtube.com/watch?v=2HjkBtxSM0g
amalrioHi amitchandak ,
thanks a lot for the reply,
I just found out, so say if I want to group by some of the Project stage say I only want to group the totals for year by when it is implementation? and not whne colse out and define, how do I do that
Thanks again mate
Hi amalrio
If you want to sum the values by year and project, you could try group by function in power query editor.
My test table:
I unpivot 2020 and 2021 column , then use gourp by function. Result is as below.
If this reply still couldn't help you solve your problem, please provide me with your screenshot of the result you want. This may make it easier for me to understand your requirement.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
amalrio , Not very clear. But at visual level you can have year as group or filter depending on the visusal
