Gantt chart; Time focus, not task focus.

[Anonymous]

Hi!

A while back I had an inquery on the use of the "Gantt" visual  where I asked about subsets of dates within the chart (https://community.powerbi.com/t5/Desktop/Gantt-Chart-focus-on-subset-of-dates/m-p/664937). The solution at the time was good enough to solve my problem but now I have further questions! 🙂

My issue is:

The way the different Gantt charts i've tested are designed to be "task focused" scope, meaning that I guess one would find the relevant tasks and retrieve information on the period the task is relevant.

    What I would love to be able to do is to retrieve the information in a "time focused" scope. What I mean is that instead of finding the tasks first, I would rather find the period first, then retrieve the tasks that are within this period.

I guess the technical issues are related to the visuals data fields are dependent on a "Start date" and an "End date". The thread I linked above offers a solution where for a task to be included in the visuel the time slicer would have to include both the start and finish date.

My ideal result would be to be able to use a time slicer to set a specific date or date range, and get all tasks that are planned to be within this period.

Thank you in advance!

Best regards

arefossa

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

You could try this way to create a measure then make the visual filtered by it.

Measure 2 = var _period1=CALENDAR(MIN(Gantt[StartDate]),MAX(Gantt[FinishDate]))
var _period2=SELECTCOLUMNS(FILTER(GENERATE(Gantt,'Date'),'Date'[Date]>=Gantt[StartDate]&&'Date'[Date]<=Gantt[FinishDate]),"Date",[Date]) return
IF(COUNTROWS(INTERSECT(_period1,_period2))>0,1,0)

It has the same logic as above post.

Best Regards,

Lin