Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Replace Values

Hi All,

 

I have uploaded my dataset into Power BI and are using the Power Query editor to change cell values. This worked fine but when new data is entered into the dataset the values are not being replaced with my 'replace value' settings.

 

Any ideas on how to automate this? For example if I were replacing "blue" values to "red", any time a new line containing "blue" would automatically be replaced to "red".

 

Hope this is clear.

 

Many thanks,

 

Elliot 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

    Maybe you can try to parameterize the 'replace value' function string with a query parameter, then you can change the query parameter to achieve dynamic replace effects.

    Regards,

    Xiaoxin Sheng

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    As you said the Replacevalue is part of the Query transformation so any new data added should go through the replace value process, can you share the M code?

  • HotChilli's avatar
    HotChilli
    Community Champion
    5 years ago

    If you've used the 'Replace Values' from the column header and everything else is equal, it will work.  So something is different about the new data (e.g. case)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    Maybe you can try to parameterize the 'replace value' function string with a query parameter, then you can change the query parameter to achieve dynamic replace effects.

    Regards,

    Xiaoxin Sheng