Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |