Slicer to effect dates only after today

[sgosselin]

Hello, I am currently making a dashboard that includes a Gantt chart for different projects within our department. I want to include a slicer that just has one button that when they press it, filters all the visuals (one table and one Gantt chart) to only include the the data where End Date is after today. I'm not sure how to go about this. I have the start and end date for each project. 

Thanks!

[amitchandak · Accepted solution]

@sgosselin , You can use relative date slicer

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Or create a new column column like this in you date table and use that

if([Date]> Today() , "After Today", [DAte] & "")

Date in slicer should be joined with end date in this case