Skip to main content

Power BI

New

Automatically remove unnecessary zeroes after decimal place for "Auto"-formatted measure

Vote (1) Share
Tim Livingston's profile image

Tim Livingston on 02 Sep 2020 20:58:48

For measures that have numerical values as their result, the "Auto" formatting usually sets decimals to 2 places and produces them regardless of whether the values the last digit is 0 or not. So if a measure has a final value of 33000, it will display "33.00K" unnecessarily. For an auto calculation, it should only refer to the last non-zero value. Essentially, the auto-formatting should be this:

33000 = 33K (not 33.00K)
33100 = 33.1K (not 33.1K)
33140 = 33.14K

Comments (1)
Tim Livingston's profile image Profile Picture

20bd895a 7a37-4912-a318-2decbfe2f7a0 on 02 Sep 2020 20:59:44

RE: Automatically remove unnecessary zeroes after decimal place for "Auto"-formatted measure

Should note it should read "33100 = 33.1K (not 33.10K)".