Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Gantt Chart - shifts

Hello everybody,

 

is ist possible to show shifts in the Gantt chart like "target goal"?

 

 

curennt

 

target goal

 

 

database

2 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    Below is one workaround which doesn't fully meet your requirements. Maybe you can try it.

     

    1. There isn't one column showing "delay", so I create one column:

     

    Delay =
    IF (
        DATEDIFF ( 'Table'[Start], 'Table'[Ende], DAY ) > 30,
        "delay",
        IF ( DATEDIFF ( 'Table'[Start], 'Table'[Ende], DAY ) <= 30, "On Time" )
    )
    

     

     

    2. Create a Gantt 2.2.3 visual. Put Delay column on Legend. Then, you can distinguish by color.

     

     

    Best Regards,
    Icey

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    Is this problem solved?


    If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


    If not, please let me know.

     


    Best Regards
    Icey