Forum Discussion

ksivaganesh99's avatar
ksivaganesh99
Icon for Helper II rankHelper II
6 years ago
Solved

Gantt chart start date issue

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...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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's avatar
collinq
Icon for Super User rankSuper User
6 years ago

Hi ksivaganesh99 ,

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