Forum Discussion

Petan65's avatar
Petan65
Frequent Visitor
5 years ago

different numbers in graph and in query

Hi, I have a problem with one report in power bi. The graph in power bi shows a different value than the sum in the power query. I do not understand how this is possible? A checksum is made in the po...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi Petan65 

I don't quite follow.  Your query results in a single value? But you then delete that?  What value are you charting in the visual?

If you use the same value in a Card visual what value does it show?

Regards

Phil

  • Petan65's avatar
    Petan65
    Frequent Visitor
    5 years ago

    In the visual, I map the sum for the period (here it's November), but there are a lot of lines in the "trzby (czk)" column, so I make this quick sum for checking. The visual should show the amount for the period, which is identical from the sum of the whole column.