topic Gantt chart in DAX Commands and Tips

Gantt chart

yasmin_kabir — Mon, 20 May 2024 13:28:25 GMT

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!

Re: Gantt chart

Anonymous — Tue, 21 May 2024 01:16:13 GMT

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.

Re: Gantt chart

yasmin_kabir — Tue, 21 May 2024 08:24:38 GMT

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?