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
mvmn
New Member

Restructure Data for Waterfall Chart

New user here....

How can i pivot data in such a way that waterfall chart has 2019-2023 by account?  Thanks!

 

My data (as an example) looks like this...

 

AccountDescriptionGroup201920202023
100000M&RProduction500500800
200000SalaryOperations10002525
300000BurdenSales200300400
400000ContractorUnified100100100
500000TaxesTerritory200200200
600000LicensingEtc.400500500

 

Would like to look like this

 

AccountDescriptionGroupValueYear
100000M&RProduction5002019
200000SalaryOperations10002019
300000BurdenSales2002019
400000ContractorUnified1002019
500000TaxesTerritory2002019
600000LicensingEtc.4002019
100000M&RProduction5002020
200000SalaryOperations10002020
300000BurdenSales2002020
400000ContractorUnified1002020
500000TaxesTerritory2002020
600000LicensingEtc.4002020
100000M&RProduction8002023
200000SalaryOperations252023
300000BurdenSales4002023
400000ContractorUnified1002023
500000TaxesTerritory2002023
600000LicensingEtc.5002023
1 ACCEPTED SOLUTION
tarunsingla
Solution Sage
Solution Sage

Select first 3 columns and click Unpivot other columns.

 

Untitled1.png

 

Gives you this:Untitled.png

 

Regards,

Tarun

View solution in original post

2 REPLIES 2
tarunsingla
Solution Sage
Solution Sage

Select first 3 columns and click Unpivot other columns.

 

Untitled1.png

 

Gives you this:Untitled.png

 

Regards,

Tarun

Thanks @tarunsingla  this did it!

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.