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
  • Mi2n's avatar
    Mi2n
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Can you filter the date field in the  "Adwords Revenue and Cost" table to have only the value Apr 22, 2016 in the Query editor and provide a screenshot?

     

    The only way that the revenue total could get reduced is, if there are any other negative values in that table for that date.

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

      Here is only the 22nd of April, filtered in Power Query, please..

       

      http://prntscr.com/axwyg3

       

      And not only this date is wrong. I have other tables with calculated columns and there is the same thing... I can't understand why it's happen, because earlier i did the same things and everything was ok(

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi ri2sina,

    Do you check if there are mulituple values of Revenue total on April 22, 2016 in your table visualaztion?

    Thanks,
    Lydia Zhang

    • 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