Forum Discussion

elbachaoh's avatar
elbachaoh
Frequent Visitor
3 years ago

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: ti...
Need Help
PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

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:

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

 

 

I've attached a sample PBIX file

elbachaoh's avatar
elbachaoh
Frequent Visitor
3 years ago

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