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: 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

Need Help

5 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    3 years ago

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

    • elbachaoh's avatar
      elbachaoh
      Frequent Visitor
      3 years ago

      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

       

      • 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