Reply
avatar user
Anonymous
Not applicable

Control chart - Highlight Data Points

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. 

1 REPLY 1
d_gosbell
Super User
Super User

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 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)