FIlter data on visual for date until now

[nganbla]

dear all, 

thank for reading and help me as below 

i have a visual with starting date 4/1/2020 (m/d/yyyy)

the date column have till future time like 6/1/2020

I want to filter the visual and date slicer until today only.

i am try to write a DAX with datesinbetween but it not wokrs, measure not infor wrong but visual not show.

How can I deal with this case? thank you

[v-easonf-msft · Accepted solution]

Hi, @nganbla 

Here is a demo.

You can create a calendar table as below:

Date = CALENDAR(DATE(2020,4,1),TODAY())

After establishing the relationship, use the date field in the calendar table to create a slicer to filter the fact table.

You  can refer this post to create a new column and apply it to slicer .

You aslo  can take  a try of  the relative date slicer to achieve the similar result.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@nganbla , Drag your date to page-level filter and use <=today. So last X year including today

[Anonymous]

You can add a  filter on Filters and choose between the dates you want to see it on the chart. 

[nganbla]

sorry, i want it automatically filter till today, and slicer limit to today only