Forum Discussion
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 / 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 ?
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.
4 Replies
- jdbuchanan71
Super User
Hello Anonymous
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.
- jdbuchanan71
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.