Help Using One Slicer for 3 columns

[Anonymous]

I am trying to filter my data with 1 slicer across 3 columns.  The data I have looks like this:

Project	Color 1	Color 2	Color 3
1	Red	Blue	Green
2	Green	Yellow
3	Blue	Green
4	Yellow	Blue
5	Green	Red	Yellow
6	Yellow

I would like the slicer to be:  Red, Green, Blue, Yellow, so if Red was selected, Project 1&5 would show up, if Blue was selected, Project 1,3 & 4, etc. 

Is there a way to do this? 

Thanks

[v-jiascu-msft · Accepted solution]

Hi @Anonymous ,

Please download the demo from the attachment and try it.

1. Create a new table. DO NOT establish any relationship.

Colors =
FILTER (
    DISTINCT (
        UNION (
            VALUES ( Table1[Color 1] ),
            VALUES ( Table1[Color 2] ),
            VALUES ( Table1[Color 3] )
        )
    ),
    [Color 1] <> BLANK ()
)

2. Create a measure.

Measure =
VAR _colors =
    VALUES ( Colors[Color] )
RETURN
    IF (
        MIN ( Table1[Color 1] ) IN _colors
            || MIN ( Table1[Color 2] ) IN _colors
            || MIN ( Table1[Color 3] ) IN _colors,
        1,
        BLANK ()
    )

3. Add the measure into the Visual Level Filter and filter out the blanks.

Best Regards,

[Vvelarde]

@Anonymous 

Hi, Try unpivoting the data in Query Editor.

Regards

Victor

[Anonymous]

Thanks - this is actually part of a larger data set that is currently 3,100 rows and counting and about 30-40 columns total.  Could I create a new table with just these columns and unpivot that?  Maybe a separate query that just pulls in these 4 columns and then unpivots?