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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
HersonD
Helper I
Helper I

Create an accumulated value

Hi,

I want to show an accumulative value in my Line and Stacked column chart. 

X axis - Dates

Y-Axis - Values

Line - Accumulated for each day

HersonD_0-1731312134245.png

Also, can I make it dynamic? I tried making an accumulated column in excel but when i used it in power BI it does not change values when I'm using slicers.

2 ACCEPTED SOLUTIONS
bhanu_gautam
Super User
Super User

@HersonD , Create that column in Power BI and if you want it to be dynamic use what if parameters 

 

https://www.youtube.com/watch?v=ejY64shaa-Y




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






View solution in original post

Anonymous
Not applicable

Thank you bhanu_gautam

Hi, @HersonD 

Based on your description, I created the following dataset:

vjianpengmsft_0-1731376288415.png

First, create the following two measures:

 

Values per day = SUM('Table'[Values]) 
Accumulate per day = 
VAR _date = SELECTEDVALUE('Table'[date])
RETURN 
SUMX(FILTER(ALLSELECTED('Table'[date]),'Table'[date]<=_date),[Values per day])

 

Create the following two charts and slicers:

vjianpengmsft_0-1732087059859.png

vjianpengmsft_1-1732087086827.png

vjianpengmsft_2-1732087103051.png

 

 

Modify the slicer time range and find that you get the correct cumulative for each day:

vjianpengmsft_3-1732087132414.png

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thank you bhanu_gautam

Hi, @HersonD 

Based on your description, I created the following dataset:

vjianpengmsft_0-1731376288415.png

First, create the following two measures:

 

Values per day = SUM('Table'[Values]) 
Accumulate per day = 
VAR _date = SELECTEDVALUE('Table'[date])
RETURN 
SUMX(FILTER(ALLSELECTED('Table'[date]),'Table'[date]<=_date),[Values per day])

 

Create the following two charts and slicers:

vjianpengmsft_0-1732087059859.png

vjianpengmsft_1-1732087086827.png

vjianpengmsft_2-1732087103051.png

 

 

Modify the slicer time range and find that you get the correct cumulative for each day:

vjianpengmsft_3-1732087132414.png

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

bhanu_gautam
Super User
Super User

@HersonD , Create that column in Power BI and if you want it to be dynamic use what if parameters 

 

https://www.youtube.com/watch?v=ejY64shaa-Y




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors