Can I create a visual graph easily with this data? NO experience of visualisation in Excel.

[Rhothgar]

Hi

The attached file was originally a CSV file from an app on my phone which links to the Engine ECU.

You can see the data in the app but it's too small to properly analyse on a mobile phone screen.

Is it possible to easily create the same graph in Excel by some magic function in PowerQuery?

https://1drv.ms/x/s!Ar8AkvzZJWl9iKsAZOY5C1Hqh9oJYw?e=VVm73g 

Here is what it looks like on a mobile screen as an example.  I do have more data fields selected though on the example.  Not sure if this makes any difference to the answer I am seeking.

[Rhothgar]

@Anonymous 

It's all too mind boggling for me.  Just signed up for free PowerBI account but it doesn't look like this is what I am looking for. It looks too much like a fancy chart with no ability to do anything other than create fancy visuals - WHICH IS NICE! but it's not really what I am looking for.

Like I mentioned on one of my replies, I need to be able to rapidly zoom in and out and look for discrepancies in the data.

Looks like I'll need to get my oscilloscope out and do it the old fashioned way!

[Rhothgar]

@Anonymous I accidentally accepted your answer as a solution.

I've realised that it will not work in PowerQuery which is what I asked about.  I usually ask my PQ questions in the PowerBI forum (I think? 🙄)

So we may as well close this thread down as it cannot work in Excel it seems and I don't have Power BI as it's not part of Office 365.

Thanks anyway.

I'll have to find some other forum to ask the question.

[Rhothgar]

Slowly getting there I think (just fooling myself really).

This is where I am but the axes are flipped and there is no way to change them and it won't flip because limit is 255 it keeps telling me.  It is clear that it is not actually plotting the relevant points along the time axis because it's all muddled up. and the other thing I noticed is that the  it is limitde to 8066 lines.  I've got files which will be much better than this to deal with.

[Rhothgar]

Not quite the same!  Also I really need to be able to zoom into specific sections and view data to try and work out where the fault lies.

This is where I've got.  It's TOO scrunched up.

[Anonymous · Accepted solution]

Hi @Rhothgar ,
Based on your description, you want to draw a line graph table, displaying columns and values by time, categorized by PID. Since this is the power bi forum, I will provide the steps for power bi chart creation.
First, open power query

select all the columns and remove the rows with null values.

Close and apply and create a line chart

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Rhothgar]

Hi Albert

Thanks for this.  I can get as far as removing blank rows and closing and applying but my version of Excel 365 doesn't seem to be set up like yours PLUS I get Not responding when I try to create a 2 line chart (note: not sure if that is what you've done in your example).

However, I have 64Gb so why it's doing this is confusing.  It should manipulate 8000+ rows with EASE!

I shall keep trying.  I've got another data file from today's drive which I want to analyse though no intermittent fault occurred today!

Not sure what the pbix file is but I cannot open it. It says it is corrupt.

[Rhothgar]

I managed to get this far using a Pivot Chart but it sums up all the values and isn't a graph.

It has basically summed up every value rather than plotting it along axes?