workload vs annual leave

[Bigjim]

Hi all, and thanks in advance for any help.

I have a workload tracker with data such as individual, assigned project, number of tasks, start and due dates etc.

I have an annual leave tracker, with individual, date on leave, remaining days etc

I'm trying to create a visualisation which shows an individuals assigned projects over time, and highlight or overlay where they are on annual leave.

I can create gantt charts for these trackers indivdually easily enough, I just can't for the life of me figure out how to combine them.

Any help much appreciated.

J

[v-jingzhang]

Hi @Bigjim 

My idea is to combine the annual leave data into the workload table or combine related data into a new table, and make annual leave as a new project in the project column. The difficulty is how to assign the annual leave to the tasks on the corresponding dates.

[amitchandak]

@Bigjim Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

But I am sre it need a comon date table.

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.