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 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
Solved! Go to Solution.
@JPettit ,
"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.
@JPettit ,
"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.
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
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |