Forum Discussion
Line Chart X-Axis range does not work with dynamic date
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?
1 Reply
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-Forum/ba-p/963216
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/1447523
