cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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/

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

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

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors