Forum Discussion

M_Sri's avatar
M_Sri
Frequent Visitor
3 years ago

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...
Need Help
gsksarepta's avatar
gsksarepta
Icon for Helper II rankHelper II
3 years ago

Please try to attach screenshots of the errors you are talking about, one from data view and another from query editor view so it helps in quick resolution. 

M_Sri's avatar
M_Sri
Frequent Visitor
3 years ago

  • gsksarepta's avatar
    gsksarepta
    Icon for Helper II rankHelper II
    3 years ago

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