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).
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.
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
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
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?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.