How to insert an average onto a report

Question

Hi Everyone - urgent help required.&nbsp;I have compiled a large table in Excel which summarizes sales&nbsp;value and units sold by day, by hour and by product. I am using a line and stacked column chart in Power BI which works extremely well. But I am really struggling to insert an average value either onto a separate visual or within the column chart. Any help greatly appreciated. Thanks

haozhong · Answer

Once you drag the field that you need to under "Value", you can click on the drop down and select Average.&nbsp;

danextian · Answer

Hi&nbsp;Garrett100,&nbsp;You may use DAX AVERAGE function to create an average measure but this will get the average values of a column.If you want to get an average based on something else &nbsp;you may use AVERAGEX.&nbsp;&nbsp;

v-jiascu-msft · Answer

Hi&nbsp;Garrett100,&nbsp;You could add the average value to the column or the line. Did you get any error messages?&nbsp;1Average = AVERAGE('Sales'[Quantity])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Best Regards!Dale

Forum Discussion

How to insert an average onto a report

3 Replies

Related content

Identity Insert On Warehouse table

Average and Moving Average

Weekly Average

Accumulated average

insert custom shape