Forum Discussion
How to create a slicer using values from multiple columns ?
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.
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.
2 Replies
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.
