Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am working on a Statistical Process Control Chart in power bi. Based on the deviation of data points, I want the chart to highlight some points which shows the process is out of control. I want to higlight below points-
1. if continioulsy 8 points are on either side of mean, then the 8th point should get highlight.
2. if continiously 8 points are increasing or decreasing on either side of mean, then the 8th point should get highlighted.
Please help to understand if this is possible using DAX functions.
Hi @Anonymous & @Anonymous
Did either of you ever find a solution for this?
I need to do exactly this process now for Covid monitoring so it would be a great help.
Thanks
Hi @Anonymous ,
I can't find out a Statistical Process Control Chart. Can you provide the exact name?
I'm afraid DAX functions can't highlight any points. But they can paint them in different colors. Please refer to desktop-conditional-table-formatting#color-formatting-by-field-value.
Best Regards,
Hi @v-jiascu-msft ,
Statistical process control is a method of quality control which employs statistical methods to monitor and control a process. You can check wikipedia for same. I am working on same charts and want some data points to be higlighted as per the conditions.
Hope, this helps.
Did you a workaround for this one? I have been looking for this.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
81 | |
65 | |
65 | |
61 |
User | Count |
---|---|
170 | |
115 | |
100 | |
73 | |
67 |