Forum Discussion

j_acnail's avatar
j_acnail
New Member
9 years ago
Solved

(Newbie) Cumulative graphs with dates as columns

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:

 

Nametypejulyaugustseptemberoctobernovember
name 1actual2,3456,7896,7897,8914,456
name 1budget1,2345,6789,1233,2347,789
name 2actual4,5671,2342,2345,6784,456
name 2budget7,8912,3454,5676,7893,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.

 

  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.