Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
How can I rename the colomn name in a Matrix table when I show value as "Percent of grand total"?
Solved! Go to Solution.
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/
@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))
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/
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |