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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
tlwest86
Helper I
Helper I

Line Chart with Cumulative Total Issue

I am wanting to create a line chart that shows our cumulative total of incoming and outgoing products by week for this fiscal year.  I tried the following DAX but could not get desired results.  The DAX does not return an error but the line graph does not update.  Can someone please look at my file below?

 

Cumulative Total Completed Column =
CALCULATE (
SUM('Pending & Completed ALL ADS'[Completed Claims Column]),
FILTER (ALLSELECTED('Pending & Completed ALL ADS'), 'Pending & Completed ALL ADS'[Comp Date] <= MAX ('Pending & Completed ALL ADS'[Comp Date])))

 

Cumulative Line Chart 

 

I greatly apprecaite your help in advance!!!! 🙂

2 REPLIES 2
tlwest86
Helper I
Helper I

Anyone that can assit with making this a cumulative line chart?

tlwest86_0-1646314555468.png

 

Hi  @tlwest86 

Does this chart only show the count per week?  I have sent an access request, please check.

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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