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.

         

    • GilbertQ's avatar
      GilbertQ
      Super User
      9 years ago

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