Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In Power BI Desktop I have made changes in Power Query by Replacing Values in a column. Those changes correctly flow into the spreadsheet view, but when I go to edit the grouping of the column, the Replace Value changes do not show in the Edit Groups interface. See image. Any idea why the Ungrouped Values data is not reflecting the refreshed data values?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
According to my research, I suggest you to check the steps list on the right of the page that if the step “Replace value” is before the step “Group data”.
If not, I think you should first replace the value then group the updated data.
Thank you very much!
Best Regards,
Community Support Team _Robert Qin