Wrong data showing in Dataview

[M_Sri]

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 column resullts are showning wrong.

Please help me.

I tried refresh option and current file settings in options from menu tab.But not working.

Thank you,

Srilatha.

[gsksarepta]

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]

Thank you for your reply.

I have attached the screenshots in below reply.

Thank you,

Srilatha.

[M_Sri]

[gsksarepta]

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.

[archuleta28]

Hi @M_Sri , Can you share pbix file for the same? removing any confidential data? That would help to look into the issue.

[M_Sri]

Hi Archuleta,

Thank you for the reply.

I am not finding any option to attach the pbix file.Please find the below link.

https://drive.google.com/file/d/1SZCJDENOFCJxhH6zh_BDAsKiKkiBo01r/view?usp=share_link 

Thanks,

Srilatha.