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
This one is a must have for our data customers.
RE: Change column labels/names in the visual
We need this badly. Its currently the sore spot in all our dashboards at the moment.
RE: Change column labels/names in the visual
We need this badly. Its currently the sore spot in all our dashboards at the moment.
RE: Change column labels/names in the visual
This is a must for us, someone did find a workaround on this ?
or an acknowledgement from MS for the roadmap ?
RE: Change column labels/names in the visual
We accomplish this via the laborious task of rebuilding "labels" using DAX formulas. We reference the source technical name that then allows us to have both fields in the data model, the original source and the field we place on the visualization. ShortName = SUM(FACT[LongerTechnicalFieldName])
Renaming in the Visualization, while more flexible, will also potentially be more labor intensive then the method described above but it is a feature we would still like to have.
Right Click -> Rename effectively removes the source field from the data model and unfortunately does not support other formulas that may reference that field as a result. We do use rename to change ALLCAPS fields out of our control to MixedCase. It is also labor intensive to maintain.
RE: Change column labels/names in the visual
Each attribute and measure could be assigned next to a sort order also a related caption attribute/name, maybe even with multi-lingual variations - like in SSAS tabular/multidimensional
RE: Change column labels/names in the visual
I literally have a customer that won't switch from Excel, until this happens. I don't blame them.
RE: Change column labels/names in the visual
Great idea!
RE: Change column labels/names in the visual
You should be able to change the caption of a field or measure within a certain visual. For example: a measure should have a very specific name, like: "Number of Contracts". But in some visuals just "Contracts" will do.
Maybe add an option to the context menu of a field in the Value pane?
RE: Change column labels/names in the visual
Please (re)tweet as much as possible to get more votes.
We needs this functionality.
https://twitter.com/FrankyAtKohera/status/816305921500610561