Columns become 0 after trasforming data

[albimarchi]

Hi, I'm a beginner at Power BI and I'm trying to figure out why my database returns 0 after trasforming or loading the dataset. The dataset is clean, the delimiter is correct and the columns has no error or wrong values. Any help would be very appreciated.Columns During Query EditorColumns after loading

[danextian · Accepted solution]

hi @albimarchi 

It seems that your data is sorted in Table View. Have you checked whether all other rows outside what's shown in your screenshot are all indeed zeroes?

[albimarchi]

You were right, it was only a matter of sorting! It was a dumb question probably ahahah but thank you so much for your help!