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 

If you showed some data that may be of help.  What value do you get in a Card visual?

So you have a single column in PQ that you are summing?  And this column is for a single period (month)?  Are you using Transform -? Statistics -> Sum to sum the column?

In the visual is it definitely charting the Sum of the column?  Double check the aggregation.

In PQ what is the data type of the column?  Is it set to any abc 123 ?  If so, you can sum that in PQ but PBI will see that as text and won't aggregate (sum) it.

Regards

Phil