- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-21-2019 12:06 PM | |||
09-24-2024 09:58 AM | |||
08-18-2024 08:33 PM | |||
05-08-2024 12:49 PM | |||
09-07-2024 09:00 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
61 | |
46 |