Deadline visual, new table?

[Baltabek]

Hi Guys,

In new to PowerBI and trying some stuff. Hopefully someone can help with with my problem.

I want to create a visual that shows if my projects passed their deadline date. I don't know if i need to create a new table or column of make a new measure.

- I have projects connected to Batch numbers already

- Deadline date connected to Batch number i don't have (How do i do this for only 3 Batches en remove the multiples?)

- Actual dates of the projects i do have already

- Show when the projects (divided in batches are passed the deadline batch date)

I hope my question is clear and someone can help me.

Kind Regards,

Baltabek

[lbendlin]

What visual type do you have in mind?  Would a Gantt Chart visual be appropriate?

[Baltabek]

Hi, 

Thanks for answering. 

I'd prefer a pie chart that shows if the actual date exceeds/ is in time/ or is really close to the deadline date. Than a table will show what projects are exceeding/ are on time or are close to the deadline date.

[lbendlin]

A pie chart?  How would that look like?