Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
57 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |