Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
79 | |
74 | |
63 | |
45 | |
44 |
User | Count |
---|---|
101 | |
43 | |
39 | |
39 | |
36 |