Showing wrong Sum

[mmohit]

Hi All,

I am creating chart where I have found Power BI is not showing correct sum.

Please find the attached snapshots.

 

[tringuyenminh92]

Hi @mmohit,

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

[mmohit]

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.

[GilbertQ]

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

[tringuyenminh92]

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

[mmohit]

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

[v-huizhn-msft]

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