cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Line Charts with Cumulative values

 I have my data like this (image below)

 

Capture.PNG

Now i need to create a line chart in Power BI. I am getting something like this (sample image below)

 

Capture.PNG

 

Just for illustration i used this chart (Target and Actuals are two lines). 

 

Now i need the lines to be cumulative over months. How can i do that in Power BI?

12 REPLIES 12
Highlighted

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted

thanks that fixed it using DATESYTD, but why wouldn't the other method work? 

Highlighted

You are welcome.  If my previous reply helped, please mark that as Answer.  You were simply not using the correct function.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors