Forum Discussion

akashsingh's avatar
akashsingh
New Member
3 years ago

Date

Dear Community,    I need to filter a Gantt Chart to show the list of ongoing projects between a specified period.  However when i use the Slicer for the start and end date, it only uses the exact...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

My idea is to create one row for each date between the start and end date.  However, this will give rise to a lot of rows (more so because you have dates starting from year 2022 ad going up till year 2026).  We can reduce the number of rows drastically by creating one row dor each month between the start date and end date.  However, in the slicer then you will not be able to see the status between any two random dates.  You will only be able to select months.  Will this appoach work for you?