Forum Discussion
janwillem
9 years agoFrequent Visitor
Rename column name in Matrix table
How can I rename the colomn name in a Matrix table when I show value as "Percent of grand total"?
- 9 years ago
The July Desktop update allows you to rename fields within a visual.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary-2/
Eric_Zhang
9 years agoMicrosoft Employee
janwillem wrote:
How can I rename the colomn name in a Matrix table when I show value as "Percent of grand total"?
Instead of the built-in "Show value as percentage of grant total", you can create a measure and format it as Percentage. See more in the attached pbix file.
whateverName you like = SUM(youTable[Value])/CALCULATE(SUM(youTable[Value]),ALLSELECTED(youTable))
robofski
9 years agoResolver II
The July Desktop update allows you to rename fields within a visual.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary-2/