Running Total with Date Table but non-date X-Axis

[unknownhi]

Hi everyone, I have been working on this visual for days now and cannot figure it out.

I want to create a cumulative graph of my revenue, which is a column called Revenue in my table Business Figures. I have a separate date table and all other suggested solutions to users that have posted about issues with the running total, and if I use the dates on the x-axis, my running total also works without problems. However, I need the x-axis to be a different column from the same table: the Session in which the revenue was accumulated. The Session does not belong to any date hierarchy itself, but having the date column in my table, I will use the date to sort the Session axis.

My issue is that if I use my running total with the following formula, I get a continuous line only when using StartDate on the x-axis. When I use Session, I have breaks in the line in the Sessions where I don't have any revenue value. This makes sense, as I know I will only get a continuous line by using a date table in the case of missing revenue values. Is there any way to "combine" the use of a date table to get a continuous line with having Session labels on the x-axis instead of the dates?

Revenue Running Total = 
CALCULATE(
SUM('Business Figures'[Revenue]),
FILTER(
ALL(Session),
ISONORAFTER(Session[StartDate], MAX(Session[StartDate]), DESC)
))

[lbendlin]

Not really.  Your x axis is either continuous or categorical. There's no in-between.

Are the sessions sortable in a meaningful way?

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...