Skip to main content

Power BI

Under Review

Add Upper and Lower Control lines to charts

Vote (80) Share
Michael Robson's profile image

Michael Robson on 06 Dec 2014 00:26:47

Charts often benefit from showing upper/lower control lines that show a certain number of deviations from the average. A common example is a funnel plot, essentially an extension of a bubble chart but allowing individual series to have their own plot. See here for an example in Excel:http://www.kurtosis.co.uk/technique/funnel/index.htm

Administrator on 06 Dec 2014 06:19:09

Great idea, Michael. I think the key elements of this are the upper and lower control lines and the central average. They're valuable additions to any chart, not just a funnel plot, so I've updated the title to reflect it. Please keep voting if you think this would be helpful!

Comments (3)
Michael Robson's profile image Profile Picture

Tim Des Rosiers on 05 Jul 2020 23:32:20

RE: Add Upper and Lower Control lines to charts

Very helpful for large scale data allowing the consumer to quickly identified anomalies of known upper and lower limits of a system. Excel allows you to build the Upper/Lower limits while I can't seem to find how Power BI supports this capability.

Michael Robson's profile image Profile Picture

Power BI User on 05 Jul 2020 23:22:59

RE: Add Upper and Lower Control lines to charts

Yes, I think that is useful

Michael Robson's profile image Profile Picture

Trevor on 05 Jul 2020 23:10:37

RE: Add Upper and Lower Control lines to charts

Is this still under review? Looking to build some Statistical Process Control charts, and this would really be nice.