(Newbie) Cumulative graphs with dates as columns

[j_acnail]

Hi,

Hi there

I've a task to work with a given excel spreadsheet which structure I can't change.  It has distributed data as follows:

Name	type	july	august	september	october	november
name 1	actual	2,345	6,789	6,789	7,891	4,456
name 1	budget	1,234	5,678	9,123	3,234	7,789
name 2	actual	4,567	1,234	2,234	5,678	4,456
name 2	budget	7,891	2,345	4,567	6,789	3,345

It has a Line and clustered column chart (cumulative), but I wonder how can I show the same charts with Power Bi. I've tried different methods without success.

Any help/ideas?

Thank you.

[Seth_C_Bauer · Accepted solution]

@j_acnail All you need to do is import the Excel file, select the columns to unpivot the months by (Name, Type) right click, unpivot other columns and this will pull things into rows that you can use.

[j_acnail]

Thanks, that's what I needed.