Forum Discussion
How to Change how data is formatted?
Hi, I'm new to PowerBI so apologies if this is not at all possible. I'm trying to turn this:
into this:
Is it possible to do this in PowerQuery? I'm trying to create a resource planning bar chart similar to this, so if there's a measure I can use instead, I would appreciate that. Thank you!
Hi Anonymous
Yes, this is possible with the unpivot column function:
Please do the following:
Start table:
highlight the name column and click on unpivot other columns:
in-between result
no righ click an Attrbiute and use Replace value
Result
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
1 Reply
Hi Anonymous
Yes, this is possible with the unpivot column function:
Please do the following:
Start table:
highlight the name column and click on unpivot other columns:
in-between result
no righ click an Attrbiute and use Replace value
Result
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------