How to show line graph data only for today or earlier?

[croberts21]

I have PBI desktop v March 2023. We use the import mode to get data. 

I am graphing vacation hours taken in the past and future on a line graph and showing a trend line. However managers often enter vacation up to 6 months ahead of time. By default PBI shows all data in the dataset. I only want to graph the values from today and before. How do I do that? 

I looked in the Visual properties, under Visual tab, then X-axis, then Range, but I cannot enter a formula of "<=today()". The X-axis is my field "Month (bins)" is is the Startdate field grouped by the month.

I can choose a fixed date in the X-axis properties but that date will never change, the user would have to update that date manually and that is not an option. I just want to exclude future dates, and graph only dates from today and before.

I also have a slicer where I can choose the pay type of "Vacation" or many other pay types like regular hours or overtime hours. 

Thank you!

[amitchandak · Accepted solution]

@croberts21 , You can use relative date slicer at visual filter level 

or you can have a measure like

calculate([Measure], filter(Date, Date[Date] <= today())

You can also try min and max value measure

min measure =  today() -3650

max measure = today()

this will cut axis not data

[croberts21]

Thank you! I actually made a new column:

BeforeToday = IF(EmpTime[Start Date] < TODAY(), True, False)

And set the page filter to show only True values for this column.