Forum Discussion

justincooper88's avatar
justincooper88
Advocate II
9 years ago

Gantt Chart visual - selecting the start date?

Hello, I currently have a Power BI project going in which I am using the Gantt chart visual.  We have a larger project list in which we have projects that started much earlier than others. My questi...
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

justincooper88

 

Since the "start date" is associated with each record, when you put "start date" into column, it will definitely filter out those records without selected "start date". This is expected behavior. It's not possible to keep all records in Gantt chart and dynamically filter duration bars only.

 

Regards,

 

heyheyhey's avatar
heyheyhey
Frequent Visitor
9 years ago

Hi Simon,

 

Can I ask why that's the expected behaviour?

 

I would expect at a project-level, most people would want to use the Gantt visualisation to show a specific view (e.g. the whole of 2017).

 

This will often include projects that started in 2016 or earlier, but because we can only filter on 'Project Start Date', these projects would dissapear if I tried to give a view of 2017.

 

Thank you

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    heyheyhey

     

    As you said, each project has a start date, it's just a like "tag" associated with each record. When you filter on 'Project Start Date' only, it will just filter the underlying records which match the date range you specified in slicer. So if you select Year 2017, it will not take any records in Year 2016.

     

    Regards,

    • justincooper88's avatar
      justincooper88
      Advocate II
      9 years ago

      Hi Simon,

      That is understood, thank you. I guess what I am looking for (and sounds like heyheyhey is as well) is to be able to setup a filter/choose a start date for the visual itself rather than filtering the data to fit into the static visual.

       

      Thanks,

      Justin

      • thomdargent's avatar
        thomdargent
        Advocate I
        8 years ago

        Hi all,

         

        Has there been a fix for this?

         

        I am using the Gantt viual and would have expected the same feature mentioned by justincooper88.

         

        Is it an expected behaviour for the visual to start "today" rather than at the earliest start date from the dataset?

         

        Thanks