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
rsamoth
Regular Visitor

Modify Table to show every year as separate column

 

Hi Guys,

 

I´ve this BI Table. In The column "Time.Years" I´ve the years 2016 - 2019.

Instead of having one column with all years i would like to have seperate columns for every year.

Ashampoo_Snap_Dienstag, 7. Mai 2019_13h51m31s_001_.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Like in this excel the amount should be shown in the right year column. 

I´m sure that can be handled with Power Bi 

 

 

Ashampoo_Snap_Dienstag, 7. Mai 2019_13h56m22s_002_.png

Thanks for your help!

1 ACCEPTED SOLUTION
Larsfin
New Member

You can do this in Power Query.

 

Go to Edit Queries  and in the transform section select the column and choose "pivot column".

 

Best,

Lars 

View solution in original post

1 REPLY 1
Larsfin
New Member

You can do this in Power Query.

 

Go to Edit Queries  and in the transform section select the column and choose "pivot column".

 

Best,

Lars 

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.