Forum Discussion
Wrong data showing in Dataview
Hi all, I am new to PowerBI , I get the data from csv file. And I changed the data types and replaced N/A with 0. In query editor the data is showing correctly.But in dataview in desktop the col...
gsksarepta
Helper II
Helper IIThanks for Sharing...
I looked at the csv and pbix. The data looks different only because of the different way of sorting in Powerquery and Table view. But I verified the values for some categories and its the same. When you are trending, the way it sorted in table view doesn't matter. Make sure to sort it as you need in Query editor and create visualizations you need. You can also sort the axis based on your preference by selecting that column field and sort by different values/categories available.