Forum Discussion
Running total: by week number, over multiple years
I want to plot a Running Total of "costs" by week (there are multiple costs entries per week). The plot will run over more than a year. The problem I currently have is PowerBI sums by a "Week of Year...
Seward12533
Solution Sage
Solution SageIf the problem is just a sort order add another calculated column of the year number as text. Using FORMAT([Year],”YYYY”) and use that on your axis should now be able to sort.
See this for sample worksheet https://community.powerbi.com/t5/Desktop/Sorting-on-a-combo-chart-with-new-release/td-p/483134
See this for sample worksheet https://community.powerbi.com/t5/Desktop/Sorting-on-a-combo-chart-with-new-release/td-p/483134
I'll have to give that a shot tomorrow now. Thanks for the response. I will let you know how that goes and follow up. This seems like it should be much easier.