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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.