Forum Discussion
Aliasing Values
Anonymous In my experience you can always rename single values with Group By, the problem comes in when you need to use an 'other' group and rename the other group - it will always force some refernce at the end that it's other.
Otherwise you can use Power Query to do this ,either in existing column or first Duplicate the column. It requires lots of 'replace values' steps or this trick: https://youtu.be/cOXNbaa_02U?t=59 Or a new Conditional Column would do the trick too. I know not quite self service intuitive, but Power BI has come a long way quickly.
Definitely vote for your idea here so we can see the functionality in future releases: https://ideas.powerbi.com/
I see. Yeah, the group function is a bit iffy, especially with single group members. Sometimes you cannot rename the group to what you need, it will insist on being named like the single item.
Have you considered using a reference table? You could add that to your data model and then just use the reference column instead of the original column.
I was able to use the group function this time for the single value members. Hopefully I don't run into the issue you mentioned in the future 🤔. I'm not a big fan of creating a lot of work for something trivial. Tableau does this effortlessly. PBI needs to improve on the simple things with the "self-service" business user in mind.
Anonymous In my experience you can always rename single values with Group By, the problem comes in when you need to use an 'other' group and rename the other group - it will always force some refernce at the end that it's other.
Otherwise you can use Power Query to do this ,either in existing column or first Duplicate the column. It requires lots of 'replace values' steps or this trick: https://youtu.be/cOXNbaa_02U?t=59 Or a new Conditional Column would do the trick too. I know not quite self service intuitive, but Power BI has come a long way quickly.
Definitely vote for your idea here so we can see the functionality in future releases: https://ideas.powerbi.com/
Thanks for the info Allison!