Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
uif19085
Helper III
Helper III

Temporal evolution chart by many date columns

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.

0 REPLIES 0

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.