Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

marionelaj

Change column labels/names in the visual

Submitted by Advocate I on ‎02-13-2017 08:45 PM
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.
Status: Completed
See more ideas labeled with:
151 Comments (151 New)
Comments
michael_broenn1
New Member
‎07-05-2020 03:48 PM
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
scott54
New Member
‎07-05-2020 03:48 PM
I literally have a customer that won't switch from Excel, until this happens. I don't blame them.
scotth
New Member
‎07-05-2020 03:48 PM
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.
pbiideas1
New Member
‎07-05-2020 03:48 PM
We need this badly. Its currently the sore spot in all our dashboards at the moment.
pbiideas1
New Member
‎07-05-2020 03:48 PM
We need this badly. Its currently the sore spot in all our dashboards at the moment.
mkowalski
New Member
‎07-05-2020 03:49 PM
So can we assume this will support visuals built on any data source (such as SSAS Multidimensional)?
mouse2
New Member
‎07-05-2020 03:49 PM
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.
marionelaj
Advocate I
Advocate I
‎07-05-2020 03:49 PM
Thank you so much for the update. Looking forward to using this feature.
arielfilipa
Advocate I
Advocate I
‎07-05-2020 03:49 PM
Hi, any update on this ? It's under review since 005-03-2015...
niyati
Frequent Visitor
‎07-05-2020 03:49 PM
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.