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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Taga0228
New Member

How to Unpivot column with formular

 

IDCodeCarrier CodeAD CollectionAD Bill of ladingAD Filing ChargeAD Ocean FreightAD Surcharge for Cape of Good Hope routingAD Supplier competing offerType
4745617708400151925128940200013023F


I have resurce report as above and tried to unpivot column as below. However, seems I don't have UnPovit column button in Power Query, how to make it happen by formular or something else. thanks 

IDCodeCarrier CodeTypeCostsType
47456177084001AD Collection519F
47456177084001AD Bill of lading25F
47456177084001AD Filing Charge12F
47456177084001AD Ocean Freight8940F
47456177084001AD Surcharge for Cape of Good Hope routing2000F
47456177084001AD Supplier competing offer13023F



1 ACCEPTED SOLUTION
govind_021
Super User
Super User

Hi @Taga0228 
It is there 
Go to Transform Tab in the ribbon and there you will get unpivot columns options i tried and its working fine 
select all cost column while pressing ctrl key and select "unpivot" columns 
name value column as a Cost 
please refer below image

govind_021_0-1736848648646.png

 

View solution in original post

1 REPLY 1
govind_021
Super User
Super User

Hi @Taga0228 
It is there 
Go to Transform Tab in the ribbon and there you will get unpivot columns options i tried and its working fine 
select all cost column while pressing ctrl key and select "unpivot" columns 
name value column as a Cost 
please refer below image

govind_021_0-1736848648646.png

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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