How to do cumulative line chart in power bi

[camelia_]

Hi, i am still new to power bi and i want to do cumulative line chart . Below is my data(from 1 jan to 30 june) and i need to do cumulative weekly/quarterly/monthly line chart based on country and ast. What i know for now is that in power bi can select only one column, not same as in excel can select for example from 1 jan to 1 feb. 

Is there any alternative ways to do, or how do i arrange it in excel so that easier to do in power bi? Thanks in advance.

[gauthamboppana · Accepted solution]

@camelia_  - Please transpose the data in Power query and you can create the line charts.

1) Go to Power Query editor. Select the two columns - Country and Ast. Right click and select 'Unpivot other columns'.

2.  Your table will now look like below. Rename the column 'Attribute' to 'Date'.

3. Close and apply changes
4. Create your Line chart as you desire.

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

[camelia_]

hi @gauthamboppana  , thanks for the solution now i am able to do the cumulative line chart. Is just that why I get the same for all country? The chart suppose to have different line for each country.

And also, i want to do weekly cumulative line chart, i try to use this

 Week Number = WEEKNUM ( 'Calendar'[Date] )

but it can't detect the date in the calendar table.