Forum Discussion

RalstonT's avatar
RalstonT
Helper I
7 years ago

Average Data

Hello,   Still farily new to Power BI, and really green with DAX.  Normally in Excel I would create a new row that shows the average of the information, but I am not sure how to do it in Power Bi. ...
Need Help
Show and Tell
RalstonT's avatar
RalstonT
Helper I
7 years ago

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.

Cmcmahan's avatar
Cmcmahan
Resident Rockstar
7 years ago

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.

  • RalstonT's avatar
    RalstonT
    Helper I
    7 years ago

    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.