- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Issue manipulating Power BI into separating month columns
Greetings BI Community,
I am currently working on a dashboard assignment for a customer who request a table projecting a dollar amount spent for each month. The problem is when the data was imported into power BI the customer listed the months out into individual columns by month instead of into my column listed down by row. This has caused power BI to project the months listed in under the data section the same way under the report section when I attempt to build my table. I am currently still in the process of learning power BI in full and I have attempted to no avail to build out the table manually but seem to be running in circles, hoping that someone in the community can lend a hand!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
This is your initial data, right? You want to unify the month columns into one column, right?
Hold down Ctrl on your keyboard and select all the month columns at the same time.
Click on Unpivot Columns
You will get a column for the month, and the corresponding value for the month, due to the lack of data on my side, your side should be more detailed.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
This is your initial data, right? You want to unify the month columns into one column, right?
Hold down Ctrl on your keyboard and select all the month columns at the same time.
Click on Unpivot Columns
You will get a column for the month, and the corresponding value for the month, due to the lack of data on my side, your side should be more detailed.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous can you please provide clear details, what you tried, how your data now looks like, and what you are trying to achieve otherwise I have no idea what's happening and what you want.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Okay my apologies for the confusion. I want to build a table with the months listed down into rolls under one column. Currently when I attempt to build my monthly expense table, the months list out into individual columns as you can in the screenshot I posted below. I mentioned below in my reply that I attempted to unpivot the columns but that solution did not correct the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Please let me know if that adds more context to my issue and what I want to do.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous it will be easier if you can post sample data with the requirement. Seems like you need unpivot your data but it will be easier if you share sample data.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Parry2k,
Thank you for the quick reply. I actually tried to unpivot the data but it caused the data in the report to misfunction in the table.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-18-2023 02:39 PM | |||
11-29-2023 08:23 AM | |||
06-06-2024 05:29 AM | |||
01-27-2024 06:41 AM | |||
06-10-2024 01:20 PM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |