Visual to Show Data Range and Average

Question

Hi,&nbsp;Is there a visual that works to show a data range with a line for the average? I was playing around with an Area chart and couldn't get it to work. I would need something that looks like this:Thank you.

lbendlin · Answer

looks like a job for the R (or Python) visual.&nbsp; Alternatively, check charticulator or charts.powerbi.tips&nbsp;

amitchandak · Answer

Anonymous , check option in analytics pane, You have options for line. 
In-Line chart you have fill option that can make it like area.
https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;How about adding an average line in area chart?&nbsp;Best Regards,KellyDid I answer your question? Mark my post as a solution!

anonymous · Answer

The average line doesn't follow the data points, it just averages across the whole set.

I made measure for Max and Min and created a ribbon chart with them and an average. This isn't quite the same as the requirements, but it will have to do.

Forum Discussion

Visual to Show Data Range and Average

4 Replies

Related content

Average and Moving Average

Dynamic Y range visual calculation in two level hierarchy

Accumulated average

Weekly Average

Range and target visual