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)
RE: Change column labels/names in the visual
Same thing for analysis services sources used in direct connection mode.
RE: Change column labels/names in the visual
Definitely useful feature - please enable it. Currently with AS Tabular we have to create seperate "friendly name" columns. The same happens if we connect live to a on prem SQL db etc..
RE: Change column labels/names in the visual
You can rename them in Power BI but not Power View. Unfortunately this simple feature is a show-stopper for user adoption of Power View.
There is a connect article for this too:
https://connect.microsoft.com/SQLServer/feedback/details/778361/power-view-rename-fields
RE: Change column labels/names in the visual
I had this problem with dates. I am fairly new to Power BI and was shocked when i couldn't change field in a matrix to be a Month/Year instead of a date field.
RE: Change column labels/names in the visual
I was just wondering if this would be a useful idea. So when I change the field to be the average or count it adds this to the name that is shown on the graph.
So I think being able to edit these field names would be a good feature to have.
RE: Change column labels/names in the visual
To provide further detail: when using an oData feed the schema names for fields are shown as uneditable labels for charts and tables. This is non-sense to most users. I.e. instead of seeing "First Name" as a label, they end up seeing "txtFName". We really need to either pull the display name for the field or make this editable.
RE: Change column labels/names in the visual
Ability to edit the column headers on tables - like you can with the title. this is especially for the sum or count columns e.g. Currently displays Count of x, instead you could edit to show Total
RE: Change column labels/names in the visual
It should be possible to change the display name of fields instead of just showing the raw column name from the dataset.
RE: Change column labels/names in the visual
Scenario: User creates a new Power View report. The field list contains attributes with descriptive but very long names. The names are so long that the user can only fit 3-4 columns in a table or matrix. User cannot edit to shorten column names so more columns can fit on the page.
As Is: Users cannot edit column names without modifying underlying source (query or model).
To Be: User can modify column names so columns with long names need not be changed in source where longer names are more appropriate.