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.
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!
@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.
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
