Assistance creating a cumulative total graph

[Anonymous]

Hi all, first time posting sorry if its not quite right

I need some help with recreating a graph within power Bi, the old version created in PowerPoint had a display of cumulative total counting up while the input goes down. This is where the issue comes in, I can work out how to count a running total but not in the way that was previously done. Is this possible within power bi and if so can anyone help?

I have included a copy below with data names removed.

blue = numbers

red = cumulative total

[v-yuta-msft · Accepted solution]

@Anonymous ,

"I can work out how to count a running total but not in the way that was previously done"

<-- If my understanding is correct, your requirement is to achieve the "revert" cummulative total, right? If so, you can just change the cummulative direction from right to left of the X-axis and then use expression like pattern below:

result =
VAR Revert_Running_Total = ...
RETURN
SUM(Table[Value]) - Revert_Running_Total

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Please refer

https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601