help asap with stop summarizing data

[Anonymous]

Hi all, 

Attached are the excel im using and the power BI report i created. The excel is filtered to show how i have the date column.

My issue is I have all the data sorting in the excel by the date filter hence the first column. When filted by a specfic date in spower bi, the data is correct. But when you select more than one date, the data is accumulating the entire column and adding both data totals together when it should be adding the difference.  how can i change my excel or change my powber bi in order to achieve this 

[Anonymous]

Hi @Anonymous ,

According to your screenshot, I think you create a bar chart. As far as I know, Power BI will summarize data based on category.

Please share a sample file with us and show us a screenshot with the result you want. This will make it easier for us to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.