Skip to main content

Power BI

Needs Votes

Add control charts

Vote (325) Share
Sarmad Istephan's profile image

Sarmad Istephan on 28 May 2015 20:42:47

Add control chart as a chart type. Preferably with the ability to set 'alerts'ing based on various factors such as exceeding the upper limit or 5 positives in a row (even though still within limit).

Comments (36)
Sarmad Istephan's profile image Profile Picture

dave roberts on 05 Jul 2020 22:58:58

RE: Add control charts

Would be very useful for me as well. I've already replicated something similar in Excel, but finding it difficult to convert this to DAX. I think it requires some pretty advanced DAX skills to create the values for the graph - perhaps people could swap their ideas in the user community and see if we can come up with a solution or establish that it's not possible through DAX??

Sarmad Istephan's profile image Profile Picture

Greg Vance on 05 Jul 2020 22:57:49

RE: Add control charts

Monitoring the stability of any process (business or manufacturing) is critical. Control charts that automatically recalculate the upper and lower control limits would help users identify when a process has shifted or is trending. This would be a very powerful addition to Power BI!

Sarmad Istephan's profile image Profile Picture

Cindy Duran on 05 Jul 2020 22:56:39

RE: Add control charts

I agree that adding control charts is essential. I use QI Macros currently; however, would prefer to have all my visualizations built in one place.

Sarmad Istephan's profile image Profile Picture

Troy Erickson on 05 Jul 2020 22:56:17

RE: Add control charts

Control charts our essential for Quality control in our HealthCare industry. Clinicians need a simple integrated chart, using R is not feasible for their skill set.

Sarmad Istephan's profile image Profile Picture

Mat on 05 Jul 2020 22:47:36

RE: Add control charts

Control Charts is number one for predictive analytics. Also eight other points which would be able to choose when needed. http://blog.minitab.com/blog/statistics-in-the-field/using-the-nelson-rules-for-control-charts-in-minitab

Sarmad Istephan's profile image Profile Picture

tglah on 05 Jul 2020 22:42:49

RE: Add control charts

need this! for those that do not know R, R visuals are not very useful.... but I am happy to see the R powered visuals gallery (https://app.powerbi.com/visuals/R-powered) and am anxious for someone to share a Control Chart there.

Sarmad Istephan's profile image Profile Picture

Franco on 05 Jul 2020 22:40:10

RE: Add control charts

This will be very valuable!

Sarmad Istephan's profile image Profile Picture

John on 05 Jul 2020 22:32:51

RE: Add control charts

I'm guessing you can create a DAX code or import an R?To create a control or run chart? If so please sign post me.

Sarmad Istephan's profile image Profile Picture

Kathy on 05 Jul 2020 22:30:47

RE: Add control charts

need it.

Sarmad Istephan's profile image Profile Picture

Geoff Sears on 05 Jul 2020 22:25:50

RE: Add control charts

I agree this would be useful. User should be able to choose between methods of calculating control limits including by mean (average), median and for those who use is Standard Deviation. I have been trying to figure out how to do this through alternate means and running into a wall. What I would not want is a control chart option where you cannot tell how it is calculating the control limits, and no one seems to know which approach is being used.