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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
ThomasSan
Helper IV
Helper IV

Salesdata not in machine readable format

Hi everyone,

 

I am having the problem that sales is giving me their sales figures in the following format:

 

ThomasSan_0-1641570743230.png

 

Naturally, I would need to put those figures in a machine readable format with separate columns for month and year (see below) before I can properly use them in PBI. 

 

ThomasSan_1-1641570815621.png

 

I was searching on google and in the forum here but I was unable to find the proper answer. Can therefore anyone help me here, please?

1 ACCEPTED SOLUTION
smpa01
Community Champion
Community Champion

@ThomasSan  you can unpivot the data in PQ

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

View solution in original post

2 REPLIES 2
ThomasSan
Helper IV
Helper IV

Cool! Thank you for your help!

smpa01
Community Champion
Community Champion

@ThomasSan  you can unpivot the data in PQ

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 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