How to create a slicer using values from multiple columns ?

[AishwaryaP_]

I have a huge dataset out of which using below 3 columns I want to use in a slicer.  This is a samp-le "Data Dable" excluding other tables.

Q1	Q2	Q3
2	1	5
4	6	4
6	1	2
7	2	7
1	1	6
2	5	3
1	5	2
6	4	1
7	6	3
4	3	5

I have another table where I have labels to map to this data "Label Table"

Option	Label
1	A
2	B
3	C
4	D
5	E
6	F
7	G
8	H
9	I
10	J

I want to create a slicer where I want to display the labels from Label table and it should filter all data from "Data Table" but it should refer to all  all 3 columns Q1, Q2 & Q3 while filtering a value. eg. If we select "G" in slicer it should filter basis 7 in Q1 & Q2 & Q3 and  show all the values from the data related to this. 

[v-angzheng-msft · Accepted solution]

Hi, @AishwaryaP_ 

Try this:

Measure = IF(
    MAX('Data Table'[Q1]) in VALUES('Label table'[Option])||MAX('Data Table'[Q2]) in VALUES('Label table'[Option])||MAX('Data Table'[Q3]) in VALUES('Label table'[Option]),1,0)

Show items when the measure is 1 in filter pane.

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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

[DataInsights]

@AishwaryaP_,

Try this solution:

https://community.powerbi.com/t5/Desktop/Once-Slicer-for-multiple-columns/m-p/430979#M198545