In Microsoft Power BI, some report fields include ID numbers before the text value.
For example, in a standard sales report, an employee name may appear together with the employee ID.
If you do not need the ID values in the report, you can remove them.
Hide IDs in a field
- Select the table you want to edit.
- Click the More options button next to the field.
- Click New column.
- Add the following formula:
My responsible = SUBSTITUTE([ASSIGNED_BY], "[" & [ASSIGNED_BY_ID] & "] ", "")
After you save the formula, a new column appears in the Fields section.
Show the new column and hide the original one. Employee names in the report now appear without ID numbers.
