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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
OJAYOKAY
New Member

Simple decimal format for 'Percent of Grand Total' measure

Why is not possible to have a simple percent value displayed to 2 decimal places on a matrix report...? This is basic functionality:

OJAYOKAY_0-1679325954027.png

 

2 REPLIES 2
OJAYOKAY
New Member

It's a matrix visualisation showing counts of helpdesk support calls by support type (email, phone, web-form, etc..) across the top and IT service down the side (as rows). The default measure is a simple sum count but the user wants the values displayed as %. So I've used the 'Show values as -> Percent of Grand Total' option on the measure. But it only shows the % as a whole number - obviously for the granularity I need this is not good - because small counts just get to be shown as 0%. Therefore I have the simple need to display the % to 2decimal places e.g. 0.42%  Looks like it's not possible. Is it? If not does this mean some kind of DAX formula is needed..?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.