Forum Discussion
Incorrect Sum Display
Hi guys,
I have a simple testing data. I want to display the total for each day in line chart. However, only the first day is display the incorrect value.
Below is the sample data that I am using:
| Budgeted Period | Toy |
| 01/07/2022 | 1 |
| 01/08/2022 | 0 |
| 01/09/2022 | 0 |
| 01/10/2022 | 0 |
| 01/11/2022 | 0 |
| 01/12/2022 | 1 |
| 01/01/2023 | 1 |
| 01/02/2023 | 2 |
| 01/03/2023 | 2 |
| 01/04/2023 | 2 |
| 01/05/2023 | 3 |
| 01/06/2023 | 4 |
| 01/07/2023 | 4 |
| 01/08/2023 | 3 |
| 01/07/2022 | 4 |
| 01/09/2023 | 4 |
| 01/10/2023 | 5 |
Date Jul 2022 should show 1 instead of 5. I suspect it has added 01/07/2022 and 01/07/2023 together.
Anyone can hint me the cause so I can test myself? Thanks.
Regards.
Anonymous
01/07/2022 1 01/07/2022 4 For July 2022 you have Toy = 5, review the following screenshot:
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
2 Replies
- fahadqadir3
Solution Supplier
Anonymous
01/07/2022 1 01/07/2022 4 For July 2022 you have Toy = 5, review the following screenshot:
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos. 
Uzi2019Community Champion
Hi Anonymous
I have taken your data it is showing correct result. as you can see in the tbale and in the chart
would you pls take a table also beside the chart just to undertsnad how your data is flowing. and share the screenshot.
I dont think PBI combines randomly data there must be reason to it.
and you can also check how your data is represnting in chart by click on show as table.
I hope I answered your question!