SPC Chart: Daily run chart overlayed by quarter average

[hermskies]

I've created a daily run chart of the total count of customers (in purple) overlayed by quarter average (in green) and quarter control limits (in grey - 3 standard deviations above and below the average). 

The chart was created in excel and the data for the daily count is simply two columns each row representing a day: Date and the daily count. The quarterly average is created using the average formula and i manually drag down the fixed quarter average down to the three months. 

I was wondering if there is a way to reproduce this in Power BI? Is there any DAX formulas for this? I tried using the Power BI native average line on the chart but i averages the entire range of the data (i.e. doesnt allow me to break the averages into quarter). 

Greatly appreciated if this is doable. 

[Anonymous]

Hi @hermskies,

Based on test, line chart not support dynamic limit line, I think you need to write two measures to mark the limit min/max value. 

For your requirement, I'd like to suggest you create a line chart with 'Date to 'Axis' fields, 'daily avg', 'quarter avg' and limit measures to value fields'.

BTW, I also search in office store but not found any custom visuals can achieve your requirement.

REgards,

Xiaoxin Sheng