Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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 Specialist
Solution Specialist

@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 Specialist
Solution Specialist

@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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.