Transpose/Unpivot with multiple categotries

[silvija1]

Hello,



I am a relatively new Power Bi user and I have a dataset shown in the table below in a simplified way. I have multiple ''descriptive'' categories and multiple Budget and Actual scenarios in columns by month. This table shows only three categories (from which only ITEM has unique values) and the first three months for Budget and Actual 2022.



The idea is to make a line chart with months on X-axis, and on the Y-axis values for multiple Budget and Actual scenarios, but of course, first I would have to transpose my table which I have done. After transposing I get ''Item'', ''Country'', and ''Area'' in the first three rows which is very inconvenient. I have tried unpivoting multiple ways but it is not working with this data set.



I must mention that my Excel data has to be organized this way, in other words, I need to keep months in columns because there are multiple categories as shown in the table. Any ideas are very welcome!



Thank you in advance for your responses,

S.

			Budget '22			Actual '22
ITEM	DIVISION	AREA	Jan	Feb	March	Jan	Feb	March
Material	HR	Corporate	50	70	45	20	15	8
Printing	Postal	Corporate	40	40	50	5	7	16
Equipment	Maintenance	Individual	60	30	70	25	7	20
Marketing	Advertising	Corporate	80	30	90	30	9	43
Clients	Advertising	Individual	50	30	10	10	17	5