Forum Discussion
Solved
Grouping column values doesn't work with replaced values
After I do a Replace Values in Power Query, the replaced strings are not recognized when grouping column values. The original strings still show up in the grouping window, while the new strings appea...
After many unsuccessful fixes, I found out it was because the strings had an invisible character that was messing up the grouping. Even though the values were getting replaced in PQ, they were showing up in their original form in the grouping feature. This extra step in PQ solved the problem:
= Table.TransformColumns(
#"Replaced Value2",
{"column", each Text.Trim(Text.Clean(_)), type text}
)Where "Replaced Value2" is the step where I did my Repace Values, and "column" is the colum with said values.
ryan_mayu
Super User
Super UserPQ follows the steps strictly.
Please Ensure Replace Values Happens Early
Move the Replace Values step as early as possible in your Power Query steps, ideally before any grouping or other transformation referencing that column.
if ths does not work, pls provide some sample data and expected output.