Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Report Value is different from the source data

Hi, 

 

After upload the excel source file and refresh on Power BI desktop, i found that the value on the report (desktop) is different from the source file:

 

Value from the excel source file:

Jul 22 - 134

Aug 22 - 151

Sep 22 - -36

Oct 22 - 572

Nov 22 - 833

Dec 22  - 524

Total: 2178

 

Below is the value on the report

 

Please advise, thank you. 

 

Cheers,

MKWAN

 

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    I use the table you provide to create a visual in Power BI Desktop, it shows normally.

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you but i don't understand.

     

    Hereafter is part of the excel source file, the total sum value of each month was on my first message.  When i create a visual on Power BI, the total sum value of each month is different from the source file. 

     

    Visual created on Power BI

    Thank you.