Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello
I am locking for a way to calculate / display a cumulative Sum. See the red line below:
Sadly, I was not able to find a solution. Has anyone an idea on how this would work?
Thanks
Hi @Markus_P ,
Create measure
Cumulative Total = CALCULATE( SUM('Table'[Wert]), FILTER( ALL('Table'), 'Table'[Date] <= MAX('Dimdate'[Date]) ) )
Then add Cumulative Total on Y-axis and date on X-axis.
Thanks
This Works, Tanks.
I was wondering if there is a way to do this when my filter are no Values and are not in an Alphabetical Order. Therefore, I wand to use a custom order. I can create a second column that has a ranking information. But I use this then I can’t show the “real” Date in the visual.
@Markus_P See this video for a running total:
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |