Forum Discussion
Average Data
All of this heavily depends on the context in which you're calculating this average. Is it only when you have a manager selected, or if no manager is selected, should it average all associates? Once you've selected a manager, should the comparison average never change?
So just to be clear, you have performance data for associates. Individuals are grouped under a manager. You want to display each individual's aggregate data in a chart, as well as displaying the same aggregate data for the entire team in the same chart.
Is this correct? What kind of visualization are you using? Do you still want the average of the team as a comparison line, or should the team show up as another "person" in the list alongside the associates it is aggregating?
Hello,
Thanks for the reply.
I am using a line chart, and a bar chart for different points of data. I would like the manager's team average to be shown when that manager is selected. I would prefer to have the average of the team shows as another "person" so we can compare side by side. In the excel example shown above that is what I created with the charts. I had a line for the average of the team that was always constant. Then I selected the average, and the associate in a slicer to compare.
Unfortunately, in PowerBI, there's not a good way to create a virtual row and display it in the default visuals alongside the non-aggregated data. You could create a second chart, hide the scale/title/legend/etc and put it into position next to the other table so it overlaps slightly and looks like another data cluster.
Hi,
I have thought about that, but to do that for every data set that I have would probably reduce the quality of the report. Trying to see what DAX language would provide a selected result in the background, but again I am not up to snuff with it.