Forum Discussion

hermskies's avatar
hermskies
Frequent Visitor
8 years ago

SPC Chart: Daily run chart overlayed by quarter average

 

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. 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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