Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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:
also, time is given in milliseconds or seconds.
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".
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
56 | |
56 | |
38 | |
29 |
User | Count |
---|---|
75 | |
62 | |
45 | |
40 | |
39 |