Skip to main content

Power BI

New

Set number of decimal places for "Show value as percent"

Vote (10) Share
Chris99's profile image

Chris99 on 22 May 2018 17:26:58

In the table and matrix visuals, when setting "Show value as percent" it always displays the value to 2 decimal places.

On the Field Formatting setting for that field the "Value decimal places" is always greyed out and shows Auto.

Allow the users to change the number of decimal places here.

By the way I know I can create a measure and set it on the Modeling tab, but that is not the functionality required.

Comments (2)
Chris99's profile image Profile Picture

c4ff06d9 1657-459b-a7eb-ded2525086b6 on 06 Jul 2020 00:17:17

RE: Set number of decimal places for "Show value as percent"

I've been after this functionality for a while - often two decimal places is completely inappropriate level to show (given a percent is out of 100 by it's very definition, 1 dp is a thousandth and two dp is a 10,000th of the data - completely unnecessary level of accuracy for most data).

Chris99's profile image Profile Picture

ee057061 b7d0-41f6-a29b-29af4b4462b0 on 06 Jul 2020 00:12:13

RE: Set number of decimal places for "Show value as percent"

Yes please.