Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
1 day ago

Dynamic format string - format

i want to understand different types of format string in case of dynamic format string , example what format should be if want to display numbers in thousands (K) or millions (M) , i get confused wit...
Need Help
power bi
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
18 hours ago

powerbiexpert22​ 

here is the quick reference for you

#,##0                 Whole number with thousands separator
#,##0.00              Thousands separator and two decimals
0                     Whole number without grouping
0.0                   One required decimal
#.##                  Up to two optional decimals
#,##0,.0 "K"          Scale to thousands
#,##0,,.0 "M"         Scale to millions
#,##0,,,.0 "B"        Scale to billions
0.0%                  Percentage with one decimal
#,##0;(#,##0);"-"     Positive; negative; zero
0.00 "units"          Add literal text