Using Access tables and queries

Hi BDibuz,

By default PBI makes the aggregation based on the type of information you have on the column (numbers = sum, Text = count; ....).

However the way the calculations are made depends on the context of your visuals although you are having a sum if you place the correct columns on your viusal should show you only that value for the specific context.

In this case if you place the year-weeknumber as X-axis and and the values should return the correct value except if you have more than one line in your table per week, for example if you have a customer on each line so the visual will give you the sum of all the lines in that week and not of the single week value, in this case you need to add in the legend or change the type of chart and give the context of the customer.

Can you share a sample of your data and expected result?

Regards,

MFelix