Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need some help with power bi

    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 /...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous  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