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

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