Hi Power BI nerds,
I am trying to filter the table by a specific date , which is working fine for the table but the gantt chart does not update as per the date filter.
so i have used this to do the sum in minutes and the filter for dates in between two dates :
Duration in Fence = CALCULATE(SUM('Fleetsu Time Asset In Fence'[Duration in Fence Minutes]),FILTER('Fleetsu Time Asset In Fence','Fleetsu Time Asset In Fence'[Entered_EventTimeStamp]<=MAX('Date DIM 2'[Date 2])&&'Fleetsu Time Asset In Fence'[Exited_EventTimeStamp]>MAX('Date DIM 2'[Date 2]))) --- this filters the table when the measure is added into the table but the gant chart does not update , i will attach the pbix and excel file
