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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

One column for each year, how to get it all in same chart with years on X-axis?

Hi, 

I got a big dataset and it ends with 10 columns that shows actual volume/forecasted volume. 

Like this: 
Volume 2020, Volume 2021, Volume 2022, Volume 2023 etc.

Fraita_1-1674718059292.png

 

No dates are attached to the dataset. 

How should i do my transformation in Power Query so that all the information is still attached too the volume but so I can visualize it on a timechart/barchart with the years (2020, 2021, 2022 etc.) on X-axis and the volume for the different years on Y-axis?
Like my example below.

Fraita_0-1674717918518.png

Thanks

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Actually tried to ask ChatGPT, got this answer: 

Fraita_0-1674723914121.png



It actually works

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Actually tried to ask ChatGPT, got this answer: 

Fraita_0-1674723914121.png



It actually works

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors