Forum Discussion
FIlter data on visual for date until now
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 visu...
Hi, Anonymous
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
Super User
Super UserAnonymous , Drag your date to page-level filter and use <=today. So last X year including today