Bar chart with date ranges

[rayinOz]

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?

[Anonymous]

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.