Forum Discussion

Baltabek's avatar
Baltabek
New Member
1 year ago

Deadline visual, new table?

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

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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

    • Baltabek's avatar
      Baltabek
      New Member
      1 year ago

      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's avatar
        lbendlin
        Super User
        1 year ago

        A pie chart?  How would that look like?