Forum Discussion

Copper Contributor

Dec 08, 2021

Power BI Graphs Data That Doesn't Exist!

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

techhelpexample.xlsx1.3 MB

Platinum Contributor

Dec 08, 2021

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.

Rory123908

Copper Contributor

Dec 08, 2021

Hi Riny_van_Eekelen ! Thanks a lot for that! Would have struggled figuring that out myself! Ill go teach myself how to remove duplicates now, thanks so much! All the best.

Riny_van_Eekelen
Platinum Contributor
Dec 08, 2021
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.
- Rory123908
  Copper Contributor
  Dec 08, 2021
  Thats great! thanks! and how did you manage to get the X axis as the correct time format? did you have to do anything to the data? I was struggling plotting the data when it was not in number format!
  - Riny_van_Eekelen
    Platinum Contributor
    Dec 08, 2021
    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.