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 ...
"DAX" "Earliest date"
Gantt
lingaro
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?