Dec 08 2021 12:29 AM
Good morning everyone and thanks in advance for your help!
If you have a look at the example I have attatched, there are two columns, one is time (in number format as it wouldnt plot when it was in dd:mm:yy hh:mm:ss format) -and the other is just a variable representing depth. When I put these into power BI, I create a line graph and I put Time as the Axis and Variable 2 as the Value. The resulting plot makes no sense to me. It gives values ranging from 9800 all the way to 20,000. This is incorrect as you can clearly see on the data that the values range from around 9800-10,000 ! I have no idea why it is doing this, but I cant seem to sort it out and it is doing the same thing for other variables too so big problem for me!! If you have any advice I'd love to hear it! thanks so much everyone!
Dec 08 2021 01:16 AM - edited Dec 08 2021 01:25 AM
@Rory123908 Loaded your data into PBI and noticed that you have duplicate time stamps. The chart sums the values, so every now and then the sum for a particular time equals approx. 19,800. That why the automatic axis values range from 10K to 20K.
Remove the duplicates and the chart will look like this:
The system doesn't allow me to upload a pbix file here. Otherwise, you could have had a look into what I did.
Dec 08 2021 01:31 AM
Dec 08 2021 01:36 AM - edited Dec 08 2021 01:38 AM
@Rory123908 You can use Transform Data in PBI. Select the first column and choose to Remove Duplicates. It opens the PowerQuery editor, similar to the one in Excel.
Dec 08 2021 01:54 AM
Dec 08 2021 02:04 AM
@Rory123908 Data typed the first column to Time and just dropped it into the visual. did noting special. If you send me a direct message with your e-mail address, I can send you the pbix file.