Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi
I would like your help with a problem of mine I'm trying to do a graph in power bi were I can se cost and the budget over time like in the graph below.
The problem I have is that the data I can download comes in this format.
Cost center | Acc2 | Accont | Akt | Proj | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
11220 Logistic | 36 Sale | 36900 services sold | 778 | 778 | 778 | 778 | 778 | 500 | 500 | 778 | 778 | 778 | 778 | 778 | ||
11222 Logistic | 62 IT-cost | 62100 Rent IT-appl | -85 | -85 | -85 | -85 | -85 | -85 | -85 | -85 | -85 | -85 | -85 | -85 | ||
11223 Logistic | 64 Inv | 64500 Office appliances | -404 | -404 | -404 | -414 | -414 | -414 | -414 | -414 | -414 | -414 | -414 | -414 |
But in order for it to work properly in power BI I would like the data to have this format. Or I think I need it to be in this format. How can I create this?
Cost center | Acc2 | Accont | Month | Budget |
11220 Logistic | 36 Sale | 36900 services sold | Jan | 778 |
11220 Logistic | 36 Sale | 36900 services sold | Feb | 778 |
11220 Logistic | 36 Sale | 36900 services sold | Mar | 778 |
11220 Logistic | 36 Sale | 36900 services sold | Apr | 778 |
11220 Logistic | 36 Sale | 36900 services sold | May | 778 |
11220 Logistic | 36 Sale | 36900 services sold | Jun | 500 |
11220 Logistic | 36 Sale | 36900 services sold | Jul | 500 |
11220 Logistic | 36 Sale | 36900 services sold | Aug | 778 |
11220 Logistic | 36 Sale | 36900 services sold | Sep | 778 |
11220 Logistic | 36 Sale | 36900 services sold | Oct | 778 |
11220 Logistic | 36 Sale | 36900 services sold | Nov | 778 |
11220 Logistic | 36 Sale | 36900 services sold | Dec | 778 |
11222 Logistic | 62 IT-cost | 62100 Rent IT-appl | Jan | 85 |
11223 Logistic | 63 IT-cost | 62101 Rent IT-appl | Feb | 85 |
11224 Logistic | 64 IT-cost | 62102 Rent IT-appl | Mar | 85 |
11225 Logistic | 65 IT-cost | 62103 Rent IT-appl | Apr | 85 |
11226 Logistic | 66 IT-cost | 62104 Rent IT-appl | May | 85 |
11227 Logistic | 67 IT-cost | 62105 Rent IT-appl | Jun | 85 |
11228 Logistic | 68 IT-cost | 62106 Rent IT-appl | Jul | 85 |
11229 Logistic | 69 IT-cost | 62107 Rent IT-appl | Aug | 85 |
11230 Logistic | 70 IT-cost | 62108 Rent IT-appl | Sep | 85 |
11231 Logistic | 71 IT-cost | 62109 Rent IT-appl | Oct | 85 |
11232 Logistic | 72 IT-cost | 62110 Rent IT-appl | Nov | 85 |
11233 Logistic | 73 IT-cost | 62111 Rent IT-appl | Dec | 85 |
11223 Logistic | 64 Inv | 64500 Office appliances | Jan | -404 |
11224 Logistic | 65 Inv | 64501 Office appliances | Feb | -404 |
11225 Logistic | 66 Inv | 64502 Office appliances | Mar | -404 |
11226 Logistic | 67 Inv | 64503 Office appliances | Apr | -414 |
11227 Logistic | 68 Inv | 64504 Office appliances | May | -414 |
11228 Logistic | 69 Inv | 64505 Office appliances | Jun | -414 |
11229 Logistic | 70 Inv | 64506 Office appliances | Jul | -414 |
11230 Logistic | 71 Inv | 64507 Office appliances | Aug | -414 |
11231 Logistic | 72 Inv | 64508 Office appliances | Sep | -414 |
11232 Logistic | 73 Inv | 64509 Office appliances | Oct | -414 |
11233 Logistic | 74 Inv | 64510 Office appliances | Nov | -414 |
11234 Logistic | 75 Inv | 64511 Office appliances | Dec | -414 |
Solved! Go to Solution.
Hello @Emmeli,
The easiest way to perform this would be via PowerQuery:
- you select all the month columns;
- and unpivot them (then you can remove those columns that are not needed and rename the newly created).
Best Regards,
Alexander
R U Kidding me! It was that easy. Thank you, thank you, thank you😀
Hello @Emmeli,
The easiest way to perform this would be via PowerQuery:
- you select all the month columns;
- and unpivot them (then you can remove those columns that are not needed and rename the newly created).
Best Regards,
Alexander
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
141 | |
79 | |
64 | |
52 | |
47 |
User | Count |
---|---|
212 | |
89 | |
76 | |
66 | |
60 |