Forum Discussion

rayinOz's avatar
rayinOz
Helper III
7 years ago

Bar chart with date ranges

Hello PowerBI'ers

 

Wondering if the following is possible; the data records are user records for course completions. 

 

1. I have a column in my data table for Course Due Date. 

 

I'm wondering if it is possible to have a bar chart where a bar would represent the number of courses that are within 30 days of current date.

 

another bar for a record with a due date between 31 and 60 days of today's date

 

and so an and so forth.

 

I hope I'm stating this correctly.

 

What i'm trying to show i the number of employees who have past the due date but in groups.

 

thoughts?

Need Help
Show and Tell

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi rayinOz ,

     

    First need to calculate the due days (current date - course completion date).

    Then need to create buckets like 0-30, 31-60, 61-90, 90+

     

    Use the Bucket as Axis and count of courses on values.

     

    I hope this will solve youe issue.

     

    Please let me know if  you have any questions.

     

    Regards,

    Pavan Vanguri.