Gantt Chart, focus on subset of dates

[Anonymous]

Hi!

My question is regarding the use of the 'Gantt' visual (Gantt 1.14.3.0).

I was wondering if there is a way to focus on a subset of all the dates. I would like to be able to focus on the dates between something like this: TODAY - 7 days and TODAY + 90 days. It kind of feels like functionallity that could be regularly needed so I am hoping someone has a solution. My reason for this is because my dataset contains projects spanning for many years, while only the a few months is relevant for closer inspection.

I can't find a solution as the the data is periodical with a Start and an End date and not reported daily.

Has anyone done something similar or has the logic to solve this one? :slightly_smiling_face:

Best regards

arefossa

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To create a CALENDAR table as below.

Table = CALENDARAUTO()

Here we needn't create relationship between the fact table and the date table. After that, create a measure as below and make the visual filtered by it.

Measure = var mindate = MIN('Table'[Date])
var maxdate = MAX('Table'[Date])
return
IF(MAX(Gantt[StartDate])>=mindate && MAX(Gantt[FinishDate])<=maxdate ,1,0)

[v-frfei-msft]

Hi @Anonymous ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.