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

[walterdp]

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

[walterdp]

Hi, @v-shex-msft:

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  

[Veree]

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?

[v-shex-msft · Accepted 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