Need some help with power bi

[Rimson]

I have a table with the following layout

<id> / descr / color 1 / color 2 / color 3 / …

So for example

1 / Apple / Green / Red / Yellow

2/ Citrion / Geen / Yellow /

3/ Pepper / green / yellow / red

I would like to see all red items in a slicer

So that I can select the option “Red” and it would select

All items with

Or color 1 is red, OR color 2 is red, OR color 3 is red ?
how do I do this ?

[Anonymous]

@Rimson  If selecting three column with the same color is your end game, try creating a new column with the logic

if(color 1 = "red", if(color 2 = "red", if(color 3 = "red", "red", 0),0),0)

Then use the new column as the slicer to filter the results

[jdbuchanan71]

Hello @Rimson 

In powerquery you can use the unpivot function to turn the columns of colors into a single column that you can use as a filter.

1. In the query editor select your color columns and go to Transform > Unpivot

Once you have that you can remove the attribute column, rename the value column and filter out blanks and you will end up with something list this:

I have attached my sample file for you to look at.

[Rimson]

Trying that out, in my visual tool I now have multiple instances of Yellow and Red to select from

[jdbuchanan71 · Accepted solution]

If, in your data, you have "yellow" and "yellow " (with an extra space on the end) they will show up as seperate items.  You can do some TRIM and CLEAN on the color column in PowerQuery to clean that up.