I’ve got the following simple visual, and added a reference line via the Analytics Pane to show the average days per new hire. However, the average associated with line (465 days) is incorrect because it’s just averaging the values of the three bars (510, 482 and 402), rather than accounting for the fact that ARD has multiple hires (which results in the correct average of 476 days per hire, per the table below). I have a measure (AverageDaysAllNewHires) that produces the correct result, but PowerBI doesn’t allow me to choose that measure since it’s not used in the visual. I also tried using a Constant Line, but that only accepts a numeric value, not a measure. Is there any way to correct the average reference line?
Alternatively, it would be fine to include a bar in the visual that represents the average for all divisions, but I couldn’t get that to work either. Any help would be much appreciated. Thanks.