Forum Discussion
Post ProdigyCreate a budget model with a few variables
Hi,
Currently, I'm working on preparing my sales budget. (Sales QTY, Revenues, COGS)
I want to input my data to excel horizontally, however in Power BI, I want to display this data vertically.
The standard solution by unpivot columns wouldn't work, because I have:
- 3 dimensions, that is Company Number, Product Groups and Months
- 3 budget version - Start, Optimistic, Negative
- 3 values - QTY, Revenues, COGS
Thanks for any help in advance!
3 Replies
- Greg_Deckler
Community Champion
pawelj795 - Can you post a better representative example of your data? Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. - amitchandak
Super User
pawelj795 , better you unpivot the data.
https://radacad.com/pivot-and-unpivot-with-power-bi
https://youtu.be/2HjkBtxSM0g
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/ 
v-kelly-msftCommunity Support
Hi pawelj795 ，
How about first merging tables from 3 dimensions into 1 table then use "unpivot " to get the expected result you need?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
