Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, need to find a way to create a temporal evolution chart, my table looks like this:
ID Status Created Closed Updated Snapshot
1 New 01/02/2022 20/05/2022 04/02/2022 14/02/2022
1 New 01/02/2022 20/05/2022 04/02/2022 22/02/2022
1 ToDO 01/02/2022 20/05/2022 25/02/2022 11/03/2022
1 Review 01/02/2022 20/05/2022 11/04/2022 15/03/2022
1 Closed 01/02/2022 20/05/2022 20/05/2022 22/05/2022
1 Closed 01/02/2022 20/05/2022 15/06/2022 24/06/2022
1 Closed 01/02/2022 20/05/2022 15/06/2022 12/07/2022
1 ... 23/08/2022
2 ToDo 02/04/2022 11/07/2022 05/03/2022 15/03/2022
2 Review 02/04/2022 11/07/2022 02/05/2022 22/05/2022
2 Closed 02/04/2022 11/07/2022 11/06/2022 24/06/2022
2 Closed 02/04/2022 11/07/2022 11/06/2022 12/07/2022
2 ... 23/08/2022
3 Closed 12/05/2022 21/08/2022 21/05/2022 22/05/2022
3 Closed 12/05/2022 21/08/2022 21/05/2022 24/06/2022
3 Closed 12/05/2022 21/08/2022 21/05/2022 12/07/2022
3 ... 23/08/2022
Updated is a date when something is changed in that ticket, can be anything, even in other columns which i didn't specified here.
Snapshot is just a date to cumulate info about a ticket, i'm using this column to calculate how many tickets were closed from the beggning of the collection.
What's the best approch if i want to display a single Line Chart with: a number of tickets that are new(prefered to use the [Created] column because a ticket will not necessary have a status of "New"), number of tickets that are closed and others for different statuses.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
21 | |
7 | |
6 | |
5 | |
5 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |