Forum Discussion
Matix - show percentage
1) try changing ALL to ALLSELECTED
2) the other thing you can try is create a Measure that gives you the values => Sum(MedsTable[Customers])
drag this Measure twice to the Values area - click on the little triangle next to the name of the second
Quick Calc - Show Values as - % of Row Total (that will also adjust to the slicers)
Good Luck! :smileyhappy:
Community Champion1) try changing ALL to ALLSELECTED
2) the other thing you can try is create a Measure that gives you the values => Sum(MedsTable[Customers])
drag this Measure twice to the Values area - click on the little triangle next to the name of the second
Quick Calc - Show Values as - % of Row Total (that will also adjust to the slicers)
Good Luck! :smileyhappy:
Thanks a lot Sean:smileyhappy:. Both solution worked.
The only thing left considering you second option is that when I calculate the measure and call it for instance "Cntids"' the percentage column's header becomes "%RT Cntis". How can I change this to a different name - say just "percent"?
I tried the right mouce click and looked at the formatting area but could not find it.
- Sean
In Excel even if you use the built-in calculations for Show Values As
you can still rename or assign a Custom Name
in PBI unfortunately this is not possible (at least no yet)!
If you want a custom name you have to write the Measure that performs the corresponding calculation!
If they add all calculations built-in Excel to PBI they will just have to let us Customize the names as well!
I'm pretty sure the more Quick Calcs they add the more people will ask for the ability to assign a Custom Name! :smileyhappy:
EDIT: Note that this is not really renaming as the Source Name remains the same.
v-huizhn-msftMicrosoft Employee