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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
elbachaoh
Frequent Visitor

Vertical Tracks for time-based data plots

Guys,

 

   I have a large dataset 900,000+rows where all data is indexed by time with 1 second resolution.

The requirement I have is to plot the data on Vertical tracks with simple line charts: time would be the y axis and x would be the chosen parameter.

 

I have not found any solution that allows to do that. PBIVizEdit.com have a published visual called "Multiple Vertical Line Chart", which is the closest thing to what I need except that it is limited with the time range that it can display (~1000 data points).

 

Any suggestions?

 

Thanks

5 REPLIES 5
PaulDBrown
Community Champion
Community Champion

Can you share some sample data and a depiction of the expected outcome?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Paul,

 

  Thanks for your response. Sample data can be found on the following link Sample Dataset

  A sketch of the required visualization can be found on the following link Sketch . It is simply the standard "LINE CHART" or "AREA CHART" visualizations but inverted, i.e. Y-Axis represents time and the X-Axis represents features.

 

Regards

 

So I've given this a shot with Charticulator, but my pc really struggles when I try to plot the full set of data points for any particular feature, and the result does not appear to be particularly useful (even when I try to add an option for scrolling the y-axis, my PC really struggles and I cannot seem to tweak the axis to any useful settings. This is what it looks like:

all.png

 I tried using a measure for average and different time intervals, in case you think any will fit the bill:
15 secs.png

 

30 secs.png

 

HM.png5 min.png15 min.pngHour.png

I've attached a sample PBIX file





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Paul,

 

  Thanks, this is pretty close and it has a many details that I can use elsewhere, and from a functional perspective it kinda does the job but won't work with my data model.

Apparently I missed some details and I apologize for that:

1-This is ultimately intended to work with SQL Direct Query data source, which means I cannot do any subsequent steps in PowerQuery

2- The chart is supposed to fit 3 or 4 features at a time

3- There should be ability to customize colors, line shapes, line...

 

I'm basically looking for same capabilities as a line/plot area chart.

 

I wish there was just a rotate button somewhere.

 

If you're out of ideas, I'd like to know if the source codes for Line and Plot Area charts available anywhere for download. I'll just swap the code sections between x and y following these tutorials

https://learn.microsoft.com/en-us/power-bi/developer/visuals/

 

Thanks

 

Sorry... can't help any further. That level of development is waaaaay beyond my scope of "expertise"...

 

It might, however, be worth trying the Developer forum?

https://community.powerbi.com/t5/Developer/bd-p/Developer 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.