Bitrix24Care

Hide ID at the beginning of a text line in PowerBI

In Microsoft Power BI, the information is displayed with the ID number in some report lines. For example, in a standard sales report, you can see that the ID number will be attached to the name of the responsible person.

If you do not need that kind of information in your report, you can easily remove it.

How to hide an ID

Select the table you are working with and click the More options button next to the desired field.

Then click New Column.

A line will appear where you need to add the function code: My responsible = SUBSTITUTE([ASSIGNED_BY], "[" & [ASSIGNED_BY_ID] & "] ", "")

After that, the column will appear in the Fields section. Make it visible and hide the previous column. The names of employees in the report will be displayed without the ID number.

Was this information helpful?
Integration specialist assistance
That's not what I'm looking for
Complicated and incomprehensible text
The information is outdated
It's too short. I need more information
I don't like the way this tool works
Go to Bitrix24
Don't have an account? Create for free
Related articles
Filter report data by different dates in Microsoft Power BI Limit the number of columns in Microsoft Power BI entity Add multiple SPAs to a Power BI report Transfer entities from CRM to Microsoft Power BI Connect Microsoft Power BI