Replace value on filtered column

Hi fanisgeorg,

You probably do it in Power Query. As you can see, you add the next steps in editing. The first step is data filtering and the second step is data replacing. Each step contains its own data set, so only filtered data goes to the last step.

To achieve what you want, you must do the following change:

Instead of using Filtered Rows and Replaced Value1 lines, please use only the last line: Replaced Value . There is a condition in which the value is to be changed.

#"Replaced Value" = Table.ReplaceValue(Source,each [Column B],each if [Column A] = "Cost Center ABCD" then "KLM" else [Column B],Replacer.ReplaceValue,{"Column B"})

If I helped, please accept the solution and give kudos! 😀

Hi Anonymous , 

I am not clear about your data structure, you could try to refer to my sample for details. If this is not what you want, please correct me and inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello, someone knows how to replace filtered values and then return to the filter of the provinces and also change the blank data for another population, I ask this because, when changing this blank data the table is left with only the data of Ceuta.