Forum Discussion
Need some help with power bi
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.
Super UserHello 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.
Trying that out, in my visual tool I now have multiple instances of Yellow and Red to select from
- 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.