Forum Discussion
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
Super UserHi 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
Only after reading this did I realize I did indeed have two values for each Year-Week. I added the "location" tag to the legend and was then able to get a stacked column chart to display values without summing for each distinct year-week.
Thank you!
