Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
@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
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |