Forum Discussion

ri2sina's avatar
ri2sina
Helper 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
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi ri2sina,

As other post, please drop Revenue total and date fields onto a table visualization and provide the screenshot, and make sure the Revenue total field is set to “Don’t summarize”, below is a similar screenshot for your reference.


 

Moreover, check the function that is used for Revenue total field in your Line Chart visualization, which is similarly shown as the following screenshot.

 


Thanks,
Lydia Zhang

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi ri2sina,

      Please click table visualization which is highlighted in the following sceenshot, then drag Revenue total and date fields into Vaules, and make sure the Revenue total field is set to “Don’t summarize”. Then post the result in this forum.




      Thanks,
      Lydia Zhang

      • Mi2n's avatar
        Mi2n
        Microsoft 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.