Line chart from the column with delimiter

Hi LP2803 

Please download the PBIX file with all the following data and visuals.

There are a few steps required but you can end up with this

You will of course need to split the packet loss column into separate values, creating new rows for each value

and I added an Index column just as an extra identifier for each series.

Then, you need to extract the Start Time which you will use on the x-axis. I also added another Index column just in case you wanted to plot all values against an arbitrary x-axis from 1 to 16.

Now by grouping on Start Time 

You can add an Index for each of the Tables for each different Start Time , you can see this Index Series column has  values from 0 to 7 for both sets of readings.

By adding the values in Index Series to the Start Time we end up with a column of times differing by 1 minute increments and this can be used as the x-axis in the line chart

Please note that not all of the above columns are required for charting, I just left them in there for you in case you wanted them for something else, but columns like Start Date and Index could be removed.

With this data you could create a line chart showing all packet loss values against time like this

But I thought it probably made more sense to split the data into 2 series and plot them separately. To do this I duplicated the 1st query twice, and in these new queries only kept the data required to chart that series.

So you can now chart Series 1 (readings taken from 2:11:52pm) and Series 2 (readings taken 2:11:20pm) separately.

Please check out the PBIX file I linked to above for all the queries, data and charts shown here.

Regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.