Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Assistance creating a cumulative total graph

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 ...
  • v-yuta-msft's avatar
    6 years ago

    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.