The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. 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 |
---|---|
65 | |
60 | |
55 | |
54 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
46 |