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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.