Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there
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.
Thanks
Solved! Go to Solution.
@Anonymous
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 @Anonymous ,
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.
Best Regards,
Jay
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |