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
mmohit's avatar
mmohit
Frequent Visitor
9 years ago

Hi

 

I took new page that time is working fine. But ever I took new page in same workbook that time showing wrong.

I have also checked Page Level and Report are emply.

 

Please find the sceenshots.

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