Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

My running total resets, i have no idea why.



I'm new to PowerBi and i just cant seem to get my line graph right. For some reason the count keeps resetting. I would really appreciate some help with this. I posted some screenshots for clarification. Thank you!







Frequent Visitor

Thanks for the replies @Syndicate_Admin @Thomas_Daubert , im working on it. Do you guys know if this date format is allright? I just can't seem to get the calender icon that i see when i look in tutorials online. 



 I got the DAX for the data from a friend.




Frequent Visitor


YTD is year to date, so it calculate from 1 january to 31 december and reset the 31 December at midnight.

you need something like that : 

Running Total COLUMN =
    SUM ( 'All Web Site Data (2)'[UniquePageviews] ),
    ALL ( 'All Web Site Data (2)' ),
    'All Web Site Data (2)'[Date] <= EARLIER ( 'All Web Site Data (2)'[Date] )

It looks like the issue you're experiencing with your line chart in Power BI is related to the way the data is being aggregated.

Based on the screenshots you've provided, it seems that the data is being aggregated by the "Date" column, and the "Count" column is being used as the value. However, the count is resetting every time the date changes, resulting in a line chart that starts at 0 for each new date.

To fix this, you need to change the way the data is being aggregated. One option is to group the data by the "Date" column and then use the "SUM" aggregation for the "Count" column. This way, the count will not reset every time the date changes, and the line chart will show the correct values.

Another option is to use the "COUNTA" function instead of "COUNT" function.

You can also use the "RUNNING_SUM" function to create a cumulative sum of the count, this way the count will not reset every time the date changes

You may also want to check if you have the correct date format in your data, this can also cause the issue.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors