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...
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

  • Dmorse's avatar
    Dmorse
    Regular Visitor
    8 years ago

    Thom,

     

    I have the same issue as you -- the start date is not reflective of the date data I am pulling from SharePoint. The Start Date reflects the current day. So far, I think it has something to do with the dataset format/type. When I create a Gantt Visualization from the excel spreadsheet I am uploading to SharePoint, the Start Date is accurate. 

     

    I'm not entirely sure why this is. I'd appreciate assistance from the team. 

     

    SharePoint dataset Start Date looks like this in Power BI: 

    12/19/2017 5:00:00 AM
     

     

    Excel dataset looks like this:

    Tuesday, January 16, 2018
     

     

     

     

    • Dmorse's avatar
      Dmorse
      Regular Visitor
      8 years ago

      Fixed my issue.

       

      StartDate field in the dataset was classified as "Data type: Text". Solved by changing to "Data type: Date"

       

      Do this by switching from Report view to Data view in Power BI, selecting my StartDate field, then going to top ribbon>Modeling tab>Formatting section>Data type: Date

       

      Now my StartDate from SharePoint dataset appears as Tuesday, December 19, 2017 without the timestamp, and the date is correctly reflected on my Gantt chart.

       

      Used smoupre's answer in this thread for reference: https://community.powerbi.com/t5/Desktop/Default-sum-Sigma/m-p/28463#M9466