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 /...
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.
Trying that out, in my visual tool I now have multiple instances of Yellow and Red to select from
jdbuchanan71
Super User
Super UserIf, 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.