Forum Discussion

pbmartin's avatar
pbmartin
New Member
8 years ago

Gantt Chart with Measure

PowerBI Newbie here.  With an Excel table as by datasource, I would like to build a Gantt chart that aggregates Task Category then shows the minimum Start Date and a Duration that is the difference b...
Seward12533's avatar
Seward12533
Solution Sage
8 years ago
Measures have to be with aggregate calculations. Datevalue (if it’s even a Dax function) is a discrete calculation. Should just simply be

"Start = MIN(Tasks[In-Home]) // assumes Tasks[In-Home] is a date.
  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Seward12533,

    Due to the nature of Gantt Chart, a start date for each task is essential. So we can not use a measure in a start-date level, we must put a column there. It's a truth after test. Please rethink your sample data and feature of Gantt Chart.

    Best Regards,
    Angelia