Forum Discussion
RE: Rename the filed values
Hi all,
i want to rename the filed values like
i have a filed
Region:
EMEA
AsiaPacific
Americas
now i want to rename AsiaPacific to APAC
how to do ? where to do ?
Best
Chanty
First select the table you want to add column to, this is visible in the Fields pane to the right of Power BI desktop
Now select the menu "modeling" and select "new column"
Write a formula similar to:
MyNewColumn = switch(
[old column name],
"old value1", "new value 1",
"old value 2", "new value 2"
)Then you can change the slicer field to the new column name
Anonymous
This is in the query editor window. You are looking at the main window. The query editor where you did the Replace values earlier. It's that same menu.
11 Replies
Hi Anonymous
Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures.
If I understand correctly, you can do this quickly in the query editor. Just click on the column with the right button of the mouse and you'll get a menu. Choose "Replace values" and there just enter 'AsiaPacific' in 'Value to find' and 'APAC' in 'Replace with'
Hi Anonymous,
You can change the value in the query editor "edit queries", then select the colum, right click and "Replace values".
You can also keep the original values and create a correspondance table and create a relationship between your tables.
Best
First select the table you want to add column to, this is visible in the Fields pane to the right of Power BI desktop
Now select the menu "modeling" and select "new column"
Write a formula similar to:
MyNewColumn = switch(
[old column name],
"old value1", "new value 1",
"old value 2", "new value 2"
)Then you can change the slicer field to the new column name
