- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
Proud to be a Super User! |
|
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
Proud to be a Super User! |
|

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-16-2024 12:10 PM | |||
07-03-2024 01:19 AM | |||
01-12-2023 09:58 AM | |||
Anonymous
| 06-21-2023 08:35 AM | ||
02-21-2024 11:05 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |