Forum Discussion

mmohit's avatar
mmohit
Frequent Visitor
9 years ago

Showing wrong Sum

Hi All,   I am creating chart where I have found Power BI is not showing correct sum. Please find the attached snapshots.    
Need Help
tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
9 years ago

My guessing that root cause is your data and data format, could you allow me to observe it?

mmohit's avatar
mmohit
Frequent Visitor
9 years ago

I have checked datatype is Decimal Number. Here is sceenshot.

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi mmohit,

     

    What do you mean "But ever I took new page in same workbook that time showing wrong"? Based on the screenshot, the result is less than data shown in Excel, do you add any filter or slicer?

    Best Regards,
    Angelia