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

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.

     

2 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    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.