Forum Discussion
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
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.
HersonD , Create that column in Power BI and if you want it to be dynamic use what if parameters
- Anonymous1 year ago
Thank you bhanu_gautam
Hi, HersonD
Based on your description, I created the following dataset:
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:
Modify the slicer time range and find that you get the correct cumulative for each day:
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.
2 Replies
- bhanu_gautamSuper User
HersonD , Create that column in Power BI and if you want it to be dynamic use what if parameters
- AnonymousNot applicable
Thank you bhanu_gautam
Hi, HersonD
Based on your description, I created the following dataset:
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:
Modify the slicer time range and find that you get the correct cumulative for each day:
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.