Forum Discussion
Slicer to effect dates only after today
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!
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
1 Reply
- amitchandak
Super User
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