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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Resolver III
Resolver III

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
Resolver III
Resolver III

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Kudoed Authors