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!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I am working with a dataset in which each month is a separate column. I would like them, that the repspective data to have months as a single column, so that I can use it properly as an axis.
https://www.dropbox.com/s/wldqjl3vjqh1h7t/Sample%20Data%20Months%20to%20Column.xlsx?dl=0
I would apprecuate some insight on how to best transform this dataset.
Thanks!
Solved! Go to Solution.
@Anonymous
Hi, in Edit Query Select Columns Sales Person & Client and go to Transform - UnPivot other Columns.
Regards
Victor
@Anonymous
Hi, in Edit Query Select Columns Sales Person & Client and go to Transform - UnPivot other Columns.
Regards
Victor
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 52 | |
| 41 | |
| 32 | |
| 26 | |
| 24 |
| User | Count |
|---|---|
| 131 | |
| 118 | |
| 57 | |
| 45 | |
| 43 |