Data Looks good in Power Query Editor but only showing cells with 0 values in Table View

44 Views Asked by At

I'm currently learning Power BI and attempting to do a little project, I prepared the data by myself, after loading into the Query Editor for transformation et al. Everything looks good, but when I switch to Table view to build my visualization, it only shows 0 values and skip some of the data, any explanation why this is happening and suggestions on how to fix will help. I attach a screenshot for better comprehension.Before Loading

After Loading

1

There are 1 best solutions below

0
Samson Bitrus On

Found my mistake, I didn't scroll all the way down, I expected the data to be sorted by Date column by default, but it sorted by the Threes column, that's why I got all the 0's first.