Change column labels/names in the visual
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.
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
It would be great to be able to rotate text for the column headers in tables and matrixes. some of my data descriptions are lengthy and it ruins the look of the visuals.
Gudmundur Oskarsson commented
The ability to show values in matrix/columns aligned vertically is still missing.
Amanda, what you have marked 'Completed' does not provide this ability.
When will this feature be available in Power BI Report Server ??!!
Eduardo Sorensen commented
Agree with Frenk (comment on July 8, 2017). I just spent plenty of time "organizing" my data into Hierarchies, and I just found out I cannot rename the columns for fields from a hierarchy. Please provide this feature. It will be extremely useful.
Hi Amanda, this is really great. I've been waiting for this feature for ages! Thank you!
One thing though. If you use a live connection to SSAS Tabular, the "Rename" option doesn't show up for fields from a hierarchy.
Mike Tallroth commented
Other point, Can we re-order manually the itens for any field in Matrix visual? Sometimes the order from the itens should be done like a business view not by a simple alphanumeric rule.
Perfect! Can you do it for any item on the field too? This is a good feature in pivot table (on Excel) and would be very usefull on PBI.
Igor Furnas commented
Great work! Thanks for listening!
Fantastic and perfect timing. thanks to all the team!
Thank you so much! Great work!
Mimoune Djouallah commented
it is working now in July update, excellent works Guys
Filipa Ferreira commented
can you please check the topic below and provide some update on the topic ?
Poul Jørgensen commented
Alignment for headlines (left/right/centered) in Matrix/ table too would be so nice
Jorge Abreu commented
Please make available for direct query source. I don't know why but some time it feels direct query is left behind in some updates.
And it works for live SSAS connections as well :-)
Yaaaayyy!! this is awesome!
Crispin Burdett commented
I have just noticed that you can now do this within the Power BI service - right-click on a field in the field section of the visual designer and there is a rename option and you just overtype the text you want. Haven't seen this annouced anywhere.
Ivan Owen commented
Is this going out on the next version?
Well, but there is easy workaround for this. Just hide Column names and put those names as one Title. For example Title=". Price Quantity".