FILTER & Outliers

[Anonymous]

Hello, 

I have a visual that is displaying "outliers", this is a binary measure of 0's and 1's based on constrant rules. I would like to be able to click on a data point in the chart and a table that has summary details filter to display the "outlier". This is working fine, nothing power BI isn't set up for. 

However, this is my issue.....

I want to be able to display all the other observations that are of the same MPN (variable in my dataset). I haven't been able to get the table to NOT filter out all the other observations. I've know it's a combination of the ALL fuction. This is what I've used thus far and it has not worked. 

MPN_All =
ALLSELECTED(Query1[MFGPARTNUMBER])

My solution for the mean time is to use a drill through filter and have the other observations display on the next page. 

As you see below. 

I would like to display all the observations in 1 table, by selecting a data point in the chart. All the data points share a MPN number, nothing else. 

Do you have any insight into how I would do this? 

[v-xuding-msft]

Hi @Anonymous ,

Did I get you? Do you implement using the way that I suggested? If you have solved it, you could share it and mark the answer as a solution. More people will benefit here.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft]

Hi @Anonymous ,

Because I can't view your data model, maybe I can't understand clearly about your requirement. You want to show all the values from one visual and they are not filtered when you click the data, right? If it is, you could try to edit interactions.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.