Reply
HersonD
Frequent Visitor

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

v-jianpeng-msft
Community Support
Community Support

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
v-jianpeng-msft
Community Support
Community Support

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






avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)