- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 05-03-2024 03:52 AM | ||
05-08-2024 01:36 AM | |||
07-30-2024 12:17 PM | |||
05-27-2024 02:45 AM | |||
06-17-2024 08:13 AM |
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
8 | |
2 | |
2 | |
2 | |
2 |