Skip to main content

Power BI

Under Review

Add Upper and Lower Control lines to charts

Vote (77) 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

0c5160a4 f9f4-4870-80b6-8d901ac68bb8 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

7f1fb90c 011a-44e1-aaf7-fb6389b45c9b 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

c4f3e338 9caf-4ac2-8bf4-74c92ed4fd40 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.