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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Lew_14
Frequent Visitor

Bespoke Timeline Visual

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.

 

Lew_14_0-1631191522020.png

Below is the temperature data i need to overlay.

 

Lew_14_1-1631191641964.png

 

Does anyone have any suggestions on how i achieve this?

 

Many thanks!

1 REPLY 1
dm-p
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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