Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

pivot data

hello,

 

I am new to powerbi. I have tried to use my data below to pivot to my desired output and i am struggling and it is not working. Any help will be definitely helpful to me.

 

periodCategory ACategory BCategory C
Jan-1522223
Feb-1535567
Mar-1526699
Apr-1514422
May-1546733
Jun-1554534

 

DESIRED OUTPUT

periodJan-15Feb-15Mar-15Apr-15May-15Jun-15
Category A232145
Category B225566446745
Category C236799223334

 

 

THANK you!!!

2 ACCEPTED SOLUTIONS
KHorseman
Community Champion
Community Champion

In the query editor, select your Period column and hit Unpivot Other Columns. Then select Period again and hit Pivot Column. Value should be the Values column, then open the advanced options and change it to Don't Aggregate.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Sean
Community Champion
Community Champion

I would only select Period and Upivot Other Columns

Then create a Matrix place Period in Columns, Category (Attribute) in Rows and Value in Values

The data will remain in better shape for analysis than your final desired output but you'll still be able to achieve it Smiley Happy

View solution in original post

5 REPLIES 5
KHorseman
Community Champion
Community Champion

In the query editor, select your Period column and hit Unpivot Other Columns. Then select Period again and hit Pivot Column. Value should be the Values column, then open the advanced options and change it to Don't Aggregate.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Sean
Community Champion
Community Champion

I would only select Period and Upivot Other Columns

Then create a Matrix place Period in Columns, Category (Attribute) in Rows and Value in Values

The data will remain in better shape for analysis than your final desired output but you'll still be able to achieve it Smiley Happy

Anonymous
Not applicable

how do i change the order of the rows under "attribute"?

Anonymous
Not applicable

how do i change the order of the rows under attribute?

KHorseman
Community Champion
Community Champion

@Seanusually I'm the one who tells people they should use a different method instead of just telling them how to get the thing they asked for. Smiley LOL





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.