Forum Discussion
Solved
Create new rows based on column data
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 d...
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
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