I currently have a combo chart that looks like this:
The chart is based on a measure "Hours Saved" and shows values for each transaction date.
I would like to additionally have a line chart added that shows the cummulative value of hours saved up to that date.
Something like this:
Anyone know how this can be done?
Keep in mind that i do not have the values for hours saved each day in a table but it is made using a measure.
Solved! Go to Solution.
Create a cumulative measure like this
Cumm = CALCULATE(SUM(Table[hours]),filter(date,date[date] <=maxx(date,date[date])))
Cumm = CALCULATE(SUM(Table[hours]),filter(date,date[date] <=max(Table[Date])))
And use in combo chart like line and bar or line and clustered
Using your solution seems to just give the same result without accumulation.
Hi @TKLAAB ,
Refer the formula below and see if it helps.
Measure = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[date])) Measure 2 = CALCULATE([Measure],FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])))
Here's the result about my sample data.
If this not help, please share some sample data if you don't have any Confidential Information.
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Find out who's part of the program this season, and welcome the new Super Users.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.
Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.