Forum Discussion

ri2sina's avatar
ri2sina
Icon for Helper I rankHelper I
10 years ago

Wrong data on the chart

Hello!   Please, help to understand what's the problem.   I have merged new column to a table and then I've calculated with it one new custom column in Power Query. Everything is perfect, BUT... ...
Need Help
ri2sina's avatar
ri2sina
Icon for Helper I rankHelper I
10 years ago

There is only one value on each date.. The problem is that each value of Revenue total field is divided on two on the chart, so i don't think the problem is with the value on 22nd of april..

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi ri2sina,

Could you please share me the pbix file? I will check that if I can reproduce this issue using your pbix file.

Thanks,
Lydia Zhang

  • ri2sina's avatar
    ri2sina
    Icon for Helper I rankHelper I
    10 years ago

    Hi, Lydia.

    Can you please share mw your e-mail, to send the pbix?

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi ri2sina,

      Please upload the PBIX file on onedrive and share us the link.

      Thanks,
      Lydia Zhang

      • ri2sina's avatar
        ri2sina
        Icon for Helper I rankHelper I
        10 years ago

        Hi Lydia,

         

        I don't know what has happened.. Before I decided to upload pbix file on onedrive, I had refreshed it again. After that the numbers in the query table had automatically changed and became the same as on the chart. The only thing I had done was sorting and filtering numbers for my convenience.

         

        I can't understand how it could be, because earlier when I refreshed, nothing was changed. And as I wrote earlier, the numbers on the chart were twice less then in the query table.

         

        And i didn't download new version of Power Bi yet after that.

         

        Can you explain this, please?

         

        And thank you for the help!