cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
camelia_
Frequent Visitor

How to do cumulative line chart in power bi

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.

Screenshot (9).png

1 ACCEPTED SOLUTION
gauthamboppana
Solution Supplier
Solution Supplier

@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'.

gauthamboppana_0-1659114546168.png


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

gauthamboppana_1-1659114610774.png

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 !

 

View solution in original post

2 REPLIES 2
gauthamboppana
Solution Supplier
Solution Supplier

@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'.

gauthamboppana_0-1659114546168.png


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

gauthamboppana_1-1659114610774.png

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 !

 

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.

Screenshot (10).png

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors