Forum Discussion

jbotero's avatar
jbotero
Frequent Visitor
8 years ago
Solved

Extract colors from column

Hello everyone.   I have a table with several columns, one of them is the description of the product, which, among other things, has a color in the text. For example: Short sleeve shirt for men blu...
Need Help
  • shebr's avatar
    shebr
    8 years ago

    Hi jbotero

     

    If you go into your Power BI editor, add a conditional column there is an operator that allows you to specify 'contains'. You could use this to pick out the colours and set the value in a new column. See image.

     

    Let me know how you get on.

     

    Thanks

     

    shebr

     

shebr's avatar
shebr
Resolver III
8 years ago

Hi jbotero

 

If you go into your Power BI editor, add a conditional column there is an operator that allows you to specify 'contains'. You could use this to pick out the colours and set the value in a new column. See image.

 

Let me know how you get on.

 

Thanks

 

shebr

 

jbotero's avatar
jbotero
Frequent Visitor
8 years ago

Thanks!! Worked great.