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
Memorable Member
9 years ago

Hi mmohit,

 

In this case, could you please remove another data tables and keep only Actual expense then sharing with us?

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
    Memorable 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
        Microsoft 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

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    I would suggest changing your "Year" column to "Do Not Summarize"