How to Trim Line Chart Time Range to Show Past YTD Data Only

[TylerVono]

Hello,

Looking to see how to trim a date range automatically to show past year to date data only.

I have made a date table that I merged with my schedule completed job orders as I needed to set it up for a forecast.

My Y axis measure is now:

Job Order Measure = count(Merge1[scheduled_completion_date])+0

But I would like to trim the dates to show just the relevant data that is charted Past 365 days to date, currently it shows all data highlighted in red below.

I have tried adding a Min and Max Measure into my Tooltips, it is just not doing anything:

MaxMeasure = Max(Merge1[date_completed].[Date])

MinMeasure = Min(Merge1[date_completed].[Date])

Need help here, how do I trim the dates automatically?

Here is the current

Link: 

https://www.dropbox.com/s/gzw8bbffru08pbc/US%20Fabrication%20Outsource%20-%20Make%20To%20Buy%20Statu...

[amitchandak]

@TylerVono , try a measure like

Job Order Measure = if(max('Completed Jobs'[scheduled_completion_date]) >= [MaxMeasure] || max('Completed Jobs'[scheduled_completion_date]) <= [MinMeasure],blank(), count(Merge1[scheduled_completion_date])+0)

[TylerVono]

Hello Amitchandak,

So the measure works but its basically not capturing when the count is at 0, can you please let me know if there is another step?

JobOrderMeasure2 = if(max('Completed Jobs'[scheduled_completion_date]) >= [MaxMeasure] || max('Completed Jobs'[scheduled_completion_date]) <= [MinMeasure],blank(), count(Merge1[scheduled_completion_date])+0)