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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.