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

Need Help

6 Replies

  • InsightsByV's avatar
    InsightsByV
    Icon for Super User rankSuper User
    3 years ago

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

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

      • 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.
    • M_Sri's avatar
      M_Sri
      Frequent Visitor
      3 years ago

      Thank you for your reply.

      I have attached the screenshots in below reply.

       

      Thank you,

      Srilatha.