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

     

PietroFarias's avatar
PietroFarias
Icon for Resolver II rankResolver II
8 years ago

Is there any possibility in creating a column with the colors that already exists? In this way, it is easier to develop something.