Bespoke Timeline Visual

[Lew_14]

I've been attempting to find a visual that allows me to display the below sets of information on the same chart, and i'm hoping someone has come across the same scenario previously. Both charts show hourly statistics over a 24 hour period - one containing temperature readings and the other showing operational status data. So far i've been unable to find anything that achieves this other than having separate visuals, however the axes don't always align properly.

I've used the 'Craydec Timelines' visual below to show the operational status throughout the day.

Below is the temperature data i need to overlay.

Does anyone have any suggestions on how i achieve this?

Many thanks!

[dm-p]

Hi @Lew_14,

I think that the key challenge here is that Power BI visuals only have the ability to receive data from a single query against the data model, so the grain (or row context) of both 'layers' needs to match as much as possible for such a solution.

If you can get the raw data for the visual looking right in a table visual then this is a good start, as this can verify that a single dataset is workable for a more bespoke solution.

However, you have clearly looked through available visuals out there - there aren't any other visuals that you can import that support layering of multiple charts in one visual container out of the box; as such you will need to use another approach to construct such a visual if you want everything in one container.

Conventionally, the recommended approach would be to develop a custom visual to handle this as the requirements are quite specific. This can have a steep learning curve, particularly if needing to do this for a specific type of visual.

In terms of the "lowest-code" option available, a visual like Charticulator will potentially allow you to create two different plot segments that use the same scale for the x-axis and thus present two charts within the same visual container - provided that you can meet the initial requirement of being able to fit both sets of data within a single dataset for the visual. It's also possible to aggregate data within plot segments, e.g. as long as the structure makes sense then you can reduce the amount of data points in the top graph (timeline) by aggregating them by something sensible.

If you can provide your sample data, either in a copy/pastable format in the forum, or as a .pbix this might provide more context as you how we could help to solve this for you.

Regards,

Daniel