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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
tomersh
New Member

continually chart discrete events as status remaining/changing over time

Hi,Is this solution possible for a stacked bar chart featuring string events over time?
for example, "initiating" / "engaged" / "terminate" in column "state" along time, and with the purpose of the visualization showing the bars along the "time" X axis. treating each time row as a distinct point while having the bar be continuous.
also, the status might return to a previous state like:
initiating -> engaged -> initiating
Or:
engaged -> terminate -> engaged.
something similar to this:

tomersh_0-1730627750554.png

also, time is given in milliseconds or seconds.

 

4 REPLIES 4
DataNinja777
Super User
Super User

Hi @tomersh ,

 

May I ask what sort of data you have for this requirement? Do you have the durations in seconds, or start and end times for each of the stages? Also, I am a bit confused about how the order of the status can switch and reverse, and I am interested in finding out the details.

 

Best regards,

Thank you for the reply,

The data is tabular logs from some systems. the duration could be in seconds or milliseconds, but it is determined by the discrete events which are the rows.
for example, rows 1,2,3 have the status "initiate" with 23,26,31 in the "time" column.
then for rows 4,5,6 the status is "engage" with 34,37,44 in "time".
this is just an example of course.

The time always goes up, but the status can change to any known status.

I hope this makes sense.

Hi @tomersh ,

Thank you for the additional information. Does that mean that the time value 31 includes 26 and 23, instead of being the sum of all three rows? From the description 'The time always goes up,' it seems to indicate that the time of the last row for the status before the change should represent the length of the status in seconds.  Please let me know if this is correct. 

 

Best regards,

Hi @DataNinja777 ,
Thank you for the reply. The time value indicates the time where the event in the specific row occured. so in the example, the event in row 3 happened at time "31".

Helpful resources

Announcements
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 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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