Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Rhothgar
Helper III
Helper III

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

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.

IMG_1251.PNG

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

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

vheqmsft_0-1719196864932.png

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

vheqmsft_1-1719196881827.png

Close and apply and create a line chart

vheqmsft_2-1719196992760.png

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

 

View solution in original post

7 REPLIES 7
Rhothgar
Helper III
Helper III

@v-heq-msft 

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
Helper III
Helper III

@v-heq-msft 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
Helper III
Helper III

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.

Getting better but axes flipped.PNG

Rhothgar
Helper III
Helper III

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.

Not quite the same.PNG

v-heq-msft
Community Support
Community Support

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

vheqmsft_0-1719196864932.png

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

vheqmsft_1-1719196881827.png

Close and apply and create a line chart

vheqmsft_2-1719196992760.png

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

 

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
Helper III
Helper III

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?

Play.PNG

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors