Forum Discussion
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. ...
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.