Control chart - Highlight Data Points

Anonymous — Tue, 15 Sep 2020 14:43:03 GMT

Hello,

I am working on creating a Control Chart in Power Bi. I can create the chart with the LCL and the UCL but I can't highlight certain points. I want to be able to highlight points based on the deviation of data points in a sequence. So far I've used the following guide but then I get stuck:

https://exceleratorbi.com.au/six-sigma-control-charts-in-power-bi/

I want the chart to highlight some points which shows the process is out of control i.e. above or below the LCL or UCL line.

The highlight would ideally show if there are 7 sequential points are on either side of UCL / LCL line. They do not need to be highlighted simply for being over or under the UCL / LCL, there must be 7 consecutive data points for this to happen. I would think some sort of IF query linked to the calendar could select whether it meets the criteria but I am not sure where to begin or if it is possible.

I am doing this to monitor or control COVID rates so any help would be greatly appreciated.

Re: Control chart - Highlight Data Points

d_gosbell — Wed, 16 Sep 2020 22:43:15 GMT

This should be possible, but it's really hard to answer this in an abstract fashion without knowing the structure of your model. Can you post a link to an example file or upload some example data following the guidelines here https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

topic Control chart - Highlight Data Points in Report Server

Control chart - Highlight Data Points

Re: Control chart - Highlight Data Points