March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I would like display a cell value as percentage, but couldn't see an option. At the moment, I have to create a measure, and set the format for this measure. However this is very inconvenient. Any suggestions? Thanks
Solved! Go to Solution.
you can show % of grand total in a matrix visual
If you select the Sum part first that option should be available, and if you have it as a matrix you can do it as a % of the Column or row total!
Thanks for the help!
Hi, if I chanaged to Sum, I can only see below option, which is not really what I need. I am a bit surprise as I though I should be able to format the cell this way. Any other thoughts? Thanks so much for the info
Thanks for the quick response. The value is not for the Grand Total. It's for each individual row, and I can't see the option like your screen shot - see below. Am I missing something? Thanks
If you select the Sum part first that option should be available, and if you have it as a matrix you can do it as a % of the Column or row total!
you can show % of grand total in a matrix visual
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |