Not able to filter by single date the table and Gant Chart

skv17 — Tue, 19 Sep 2023 08:15:56 GMT

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

Re: Not able to filter by single date the table and Gant Chart

skv17 — Tue, 19 Sep 2023 08:10:27 GMT

https://drive.google.com/drive/folders/1kg8W5xOwuwDaM3ckNCPj10T5VmfiDTc_?usp=sharing

link to the files above

topic Not able to filter by single date the table and Gant Chart in Desktop

Not able to filter by single date the table and Gant Chart

Re: Not able to filter by single date the table and Gant Chart