Gantt chart start date issue

[ksivaganesh99]

Hi all,

I am using Gantt chartpublished by Microsoft Corportation(https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380765).

When the start date is null and duration is 0 it is picking up the present date as start date and duration as 1 day as attached in thescreenshot below. I don't want anything to e displayed in the timeline if the start date is null and duration is 0.

Any help is highly apprecited.

[v-eachen-msft · Accepted solution]

Hi @ksivaganesh99 ,

You could create a measure like the following DAX:

Measure =
IF (
    SELECTEDVALUE ( 'Table'[duration] ) <> 0
        && SELECTEDVALUE ( 'Table'[StartDate] ) <> BLANK (),
    1,
    0
)

Then add it in the filter pane and set it to show the result whose measure = 1.

[collinq]

Hi ksivaganesh99 ,

I would add a filter or a slicer to exclude those tasks that have no Start Date.