Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi everyone,
I am having the problem that sales is giving me their sales figures in the following format:
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.
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?
Solved! Go to Solution.
@ThomasSan you can unpivot the data in PQ
Cool! Thank you for your help!
@ThomasSan you can unpivot the data in PQ
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 14 | |
| 12 | |
| 10 | |
| 7 | |
| 6 |