Skip to main content

Power BI

Completed

Change column labels/names in the visual

Vote (1472) Share
Mario Nelaj's profile image

Mario Nelaj on 14 Feb 2017 04:45:43

It would be great if we could change columns labels/names in the standard visuals (Table & Matrixes mainly). In our company we have a data warehouse build to support the PowerBI tabular model with the data. The field names in the data model are not the most intuitive to our PowerBI End User. It could be great if we could change the way the field labels are shown in our tables to be more intuitive and meaningful without needing to change the field names in the data model.

Administrator on 06 Jul 2017 13:05:17

With today's release, you can now rename any field within a chart or table! Learn more in our blog post: https://powerbi.microsoft.com/blog/power-bi-desktop-july-feature-summary-2/#rename

Comments (149)
Mario Nelaj's profile image Profile Picture

25069a92 a58c-44a4-bcf4-418f4c45d72f on 05 Jul 2020 22:49:33

RE: Change column labels/names in the visual

Hi, any update on this ? It's under review since 005-03-2015...

Mario Nelaj's profile image Profile Picture

06b35ebb ac3a-473f-bd05-1ec95c8d5c15 on 05 Jul 2020 22:49:27

RE: Change column labels/names in the visual

So can we assume this will support visuals built on any data source (such as SSAS Multidimensional)?

Mario Nelaj's profile image Profile Picture

f5a387d0 4397-438c-b036-7c768d903231 on 05 Jul 2020 22:49:23

RE: Change column labels/names in the visual

This is a definite must have. We have SSAS Models with complex names do not make any sense to the end users of the reports/dashboards we build from those models. I might call a value "Sales" on a report, but of the thousands of measures and dimensions we have, that one might be called "sales_withA_lessB_avg". Having to create new measures simply because you want a report measure or dimension heading renamed is absolutely unacceptable.

Mario Nelaj's profile image Profile Picture

98bbf54e 0336-4a82-b225-524b0091fe8a on 05 Jul 2020 22:49:17

RE: Change column labels/names in the visual

Is there any way to hide the column headers in matrix and table chart ? If I am making the color of header and background color same , it is not visible but when I am printing the report
those headers are visible in grey color. Can you please help on the same and also provide suggestions to handle this problem.

Mario Nelaj's profile image Profile Picture

9a63a1a8 094c-4bf7-964b-db30786ab559 on 05 Jul 2020 22:49:00

RE: Change column labels/names in the visual

Great News. Thank you for the update

Mario Nelaj's profile image Profile Picture

3e07ddab f9ab-4126-8bf0-2c3eb56328bc on 05 Jul 2020 22:48:58

RE: Change column labels/names in the visual

Great news! Will this include all visuals??

Mario Nelaj's profile image Profile Picture

43759ad0 568b-41ec-b328-83e8516c05c5 on 05 Jul 2020 22:48:58

RE: Change column labels/names in the visual

Great! So I guess this will work immediately with direct query (ssas) as well? Because that solves partially the lack of translation support

Mario Nelaj's profile image Profile Picture

e0950c2a 57ef-43af-b977-fe7be9c3f676 on 05 Jul 2020 22:48:57

RE: Change column labels/names in the visual

Great news!
Thank you!!

Mario Nelaj's profile image Profile Picture

ece201d7 54b3-4377-89b4-c84b5cb2dc41 on 05 Jul 2020 22:48:56

RE: Change column labels/names in the visual

I don't see any responses from the experts. Is it possible to rename a column header in a Matrix or Table without modifying the data tables?

Mario Nelaj's profile image Profile Picture

b077c982 9d19-4c2e-a433-5cea99a4d89a on 05 Jul 2020 22:48:56

RE: Change column labels/names in the visual

Great news that you have started working on it! Thanks Amanda & the team.

To also take into consideration: sometimes the Labels names are not very clear, specially using quick measures.
Example: % of CT of Count "label_name"

Not very user friendly =)
And it makes the column label too long, even if we can now wrap the labels, it would be great to have it shorter.. Thanks!