Muliple Slicer Selection based on column

[Ewout]

Hi, 

I am trying to make a slicer which can turn off/on certain effects which were detected. For example: You have a truss with grapes. 

The computer has measured that truss one has one green grape, eight red grapes and 1 blue grape. Also the computers measures how many grapes have certain issues which make them not sellable. 

I want a slicer which filters every truss by the if this problem of colour is available in this truss. 

So in the case of this example, if i select "blue" Truss one and  Three will show. Truss two and four will be filtered out. 

I hope my questions is clear :D, any questions I will be happy to answer!

Truss	Red	Blue	Green	Problem 1
One	8	1	1	1
two	4	0	5	0
Three	2	5	1	3
Fout	1	0	9	1

[Ewout · Accepted solution]

I found a solution by creating a new colum measuring if the statement is "problem is there" or null. Using a slicer with this new colum and filter out the Null values will almost complete the job.

[Ewout]

Thanks for your reply, but the dataset is to big to do an easy transform (unpivot comuls). The dataset must be in this position to be working fine. Also it would be nice is some new problems were added, that adding this to powerbi wouldn't be that difficult.

[Anonymous]

Hi @Ewout,

I'd like to suggest you do unpivot on your colors and problem fields, then you can simply create a matrix showing the raw effect and write a measure as a filter to filter your records.

Unpivot columns (Power Query) 

Applying a measure filter in Power BI 
Regards,

Xiaoxin Sheng