Power BI
NewAutomatically remove unnecessary zeroes after decimal place for "Auto"-formatted measure
Vote
(1)
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)
Comments (1)
RE: Automatically remove unnecessary zeroes after decimal place for "Auto"-formatted measure
Should note it should read "33100 = 33.1K (not 33.10K)".