Incorrect Sum Display

[Anonymous]

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.

[Uzi2019]

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!

[fahadqadir3 · Accepted solution]

@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.