The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I am creating chart where I have found Power BI is not showing correct sum.
Please find the attached snapshots.
Hi @mmohit,
In this case, could you please remove another data tables and keep only Actual expense then sharing with us?
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.
I would suggest changing your "Year" column to "Do Not Summarize"
My guessing that root cause is your data and data format, could you allow me to observe it?
I have checked datatype is Decimal Number. Here is sceenshot.
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
User | Count |
---|---|
80 | |
73 | |
39 | |
30 | |
28 |
User | Count |
---|---|
107 | |
99 | |
55 | |
49 | |
46 |