Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
spagad6263
Post Patron
Post Patron

How to display table cell as percentage?

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 

 

spagad6263_0-1685999916783.png

 

spagad6263_1-1685999954433.png

 

 

2 ACCEPTED SOLUTIONS
Accelins
Frequent Visitor

you can show % of grand total in a matrix visual 
%.jpg

View solution in original post

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! 

View solution in original post

5 REPLIES 5
spagad6263
Post Patron
Post Patron

Thanks for the help!

spagad6263
Post Patron
Post Patron

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

 

spagad6263_1-1686039580050.png

 

 

 

 

spagad6263
Post Patron
Post Patron

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

 

spagad6263_0-1686000712728.png

 

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! 

Accelins
Frequent Visitor

you can show % of grand total in a matrix visual 
%.jpg

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.