Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
walterdp
Helper I
Helper I

How to create a control chart with dynamic limits (based on different filters)

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

 

 

walterdp_0-1655901936292.png

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.

 

walterdp_1-1655902122310.png

 

walterdp_2-1655902137310.png

 

Thanks!


Walter

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
walterdp
Helper I
Helper I

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?

 

 

Anonymous
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.