Relative Date of the Month

[Anonymous]

Hi,

I would like to create a gantt chart that displays the start date, length, and end date of my projects. My idea for the visual is to show all data / projects for the current year. The issue I am facing is that I have projects that repeatedly start on certain days of each month (eg., always on the first or on the fifth and so on) and their deadline is also always on a certain day of each month (eg., 10th or 20th) of each month. The raw data I have includes one column that includes just a number of the respective start (eg., 1 or 5) and one column of the respective day on which the project has to be finished (eg., 10 or 20).

How can I create a measure / column that let's me display these repeated projects on a gantt chart or in a matrix? 

Any suggestions on how to accomplish this?  Thanks a lot!

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario.

You may use Gnatt chart to display the result. Please make the visual selected, go to 'Format' ribbon, click 'General', set 'Group Tasks' on, then click 'Days off' and set it on.

Result:

Best Regards

Allan

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

[Anonymous]

Hey, thanks for your quick reply. This is what I mean:

The table shows how my data looks like and the examplary gantt chart shows roughly how I would like to have my visual in the PowerBI report. Thanks!

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.