Forum Discussion

yasmin_kabir's avatar
yasmin_kabir
New Member
2 years ago

Gantt chart

Creating a Gantt chart using Lingaro visual.

 

However, I do not want it to display past phases (highlighted in yellow), I want it to be centered around today's date (e..g, show phases on or after today's date- shown via the diamond shape). Is this possible?

 

 

thanks in advance!

 

 

"DAX" "Earliest date"
Gantt
lingaro

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi yasmin_kabir 

     

    Here are some suggestions for your reference:

     

    Use the filter pane in Power BI to filter your dataset to only include phases that start on or after today's date. This will ensure that past phases are not displayed in your Gantt chart.

    Create a DAX measure to dynamically identify today's date and use it as a reference in your visual or filters. This can help in automatically updating the Gantt chart to focus on the current date.

    Apply visual level filters to your Gantt chart to dynamically hide past phases based on the date. This approach ensures that only relevant phases are displayed.

     

    Best Regards

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

    • yasmin_kabir's avatar
      yasmin_kabir
      New Member
      2 years ago

      Hi,

       

      Thanks for the reply,

       

      when I filter to only phases on or after todays date, it doesnt show those in progress today. Also when filtering every phase, it ends up only showing programs at a date starting after the initial first phase. Is there a way to show dates/ phases currently being worked on today + future ones?