Formatting tables in PowerPivot/Excel is easy... how do I do something simple like format a number as a percentage?
I created a really simple measure:
Relative F = COUNTROWS('Symptoms')/COUNTROWS(ALL('Individual'))
but I can't format it as a percentage. And YES, I actually do see the percentage button in the formatting ribbon, but if I click on my measure, and then click the percentage format button, nothing happens.
Am I just missing the painfully obvious?
Thanks!
Pieter