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

Hi,

 

Some screenshots would help in understanding the problem better.

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

    Thank you! I've already added it!

    • Mi2n's avatar
      Mi2n
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      Hi, What is the formula used for Revenue total used in the chart.. Also can you please confirm if there are no other filters selected?

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

        hi again!

         

        The Revenue total was calculated as [value1]*[value2]*[value3], and the second value was expanded from the table2, the third value - from table 3.

        All selected filters you can see on the link

        http://prntscr.com/ax2nbg