Forum Discussion

matthewfe's avatar
matthewfe
Regular Visitor
8 years ago

Gantt chart Slicer Functionality

Hello,

 

I am attempting to create a Gantt chart to show the flow of projects happening over the course of two years. My excel document I am pulling from currently has the following columns:

1) Project Name

2) Region

3) Stage Start (for project)

4) Stage End (for project)

5) Employees

6) Employee's time % allocated to project

7-XXX) And from here I have listed every week from 1/1/2017 to 12/31/2018

 

The problem not creating a Gantt chart. I have created that with no problems. But I want to be able to use a slicer to select a date range and then ANY project that is active during that range shows up on the Gantt chart. It is not very helpful to have a 'Stage Start' and 'Stage End' slicer. I would much rather have one slicer, 'Date Range', and proceed from there.

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi matthewfe,

     

    Please create a calendar table. Drag [date] from this calendar table to date range slicer.

    dim = CALENDAR(DATE(2017,1,1),DATE(2018,12,31))

    Then, create a measure with below DAX. Add this Flag measure into visual level filter of Gantt chart and set its value to 1.

    Flag =
IF (
    SELECTEDVALUE ( Project_tab[Stage Start] ) >= MIN ( dim[Date] )
        && SELECTEDVALUE ( Project_tab[Stage End] ) <= MAX ( dim[Date] ),
    1,
    0
)

     

    Best regards,

    Yuliana Gu

    • matthewfe's avatar
      matthewfe
      Regular Visitor
      8 years ago

      This did not solve my issue. There is a chance I did not properly explain what I needed.

       

      What you did make sense but I will explain the result. There is a certain project, project X, I used to test the slicer.

       

      The start date is 6/11/2018 and the end date is 6/24/2018. I set the slicer end date to 6/1/2018 and the start date remained at 1/1/2017. The desired result would be that project X is taken out of the gantt chart. This was not the case. It made no affect on the chart whatsoever.