Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I would like to create a control chart with UCL, LCL and average that can adjust based on the filters I apply. For example, the line charts below have no filter applied
But if I select a different "Estado" or "Periodo" or even if I select a bar on the chart in the middle of the image, the "average" changes. I want to have the same but for UCL and LCL.
Thanks!
Walter
Solved! Go to Solution.
Hi @walterdp,
If you want the filter to interact with specific visuals, you can turn on the 'edit interactions' layout to change the visual interactions or try to create an unconnected table as the source of the slicer and use a measure filter to filter table records.
Applying a measure filter in Power BI - SQLBI
Change how visuals interact in a report - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
Hi, @Anonymous:
Thanks for replying. I briefly read the articles you shared and I believe they are not what I need. What I'm looking for is a way to calculate UCL, LCL and average to use them in a control chart and make those measurements dynamic, based on the filters I can use as explained in the initial post.
Thanks
W
Hello Walter,
I have the same question. I need to add extra 3 filters for the control chart.
Have you found a solution for this?
Hi @walterdp,
If you want the filter to interact with specific visuals, you can turn on the 'edit interactions' layout to change the visual interactions or try to create an unconnected table as the source of the slicer and use a measure filter to filter table records.
Applying a measure filter in Power BI - SQLBI
Change how visuals interact in a report - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
39 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |