Reply
Cavan9
New Member

How to create planned vs actual timeline visual in less than hourly granularity.

Hello.

I have a need to create a data set that visually shows variations between planned and actual timelines, within a single day, on a 5-10 minute increment basis.

Every day has an active work window of approximately 1.5-2 hours, which will be planned out in advance. Commonly, but not every day, there will be some variance (both early and late).

The data, day by day, may look something like this:

Cavan9_0-1728297392837.png

The two ways I was able to identify this were using bar charts with error bars (or a bullet graph) and through the use of a matrix. I was not sure which approach would be better suited, and was unable to create either myself.

 

Either way, the timeline needs to:

  • Start at a consistent X-Axis offset from the data it is showing (this cannot be a set number as timings vary by up to 3 hours between different groups).
  • Show the X-Axis as 5 minute increments for a matching duration of time (roughly between 90 and 120 minutes, but variable)
  • Highlight variations (both early and late) between actual and planned.

It seems like videos such as this Create A Gantt Chart In Power BI With A Matrix Visual (youtube.com) are close to what I want to be able to do, but I am unclear how to structure my data and create the measures that would do this for me on a 5 minute increment timescale 'and' highlight variations between actual and planned.

 

 

1 REPLY 1
lbendlin
Super User
Super User

 I am unclear how to structure my data and create the measures that would do this for me on a 5 minute increment timescale

Create a reference table that has these buckets prepopulated, or use GENERATESERIES to do that on the fly (multiply your date values by 288)

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)