Line Chart X-Axis range does not work with dynamic date

[Anonymous]

I have a line chart which looks at a specific item from a data table, the chart looks at two fields which are:
1. Cummulative spend on the y-axis
2. Date on the x-axis (Date is based off of a DIM Date table)

I am trying to set the maximum range of the line chart x-axis to the maximum of a date in the data table however this is not working.

However, if I put the same date in manually it will filter the x-axis range.

Max date from data table (Used in the X-Axis Range):

X-Axis Range:

Current Line Chart:

The cummulative spend goes to null after TODAY() and is then forecasted.

How do I get the dynamic date to function the same as the hardcoded date?

[lbendlin]

Have your measure return BLANK() for dates you want to suppress.

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.
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.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...