Forum Discussion
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!
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.
6 Replies
- parry2k
Super User
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 - parry2k
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.
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.
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.
