Avoid scientific notation in PowerBI

If you want a more dynamic solution or different formats at different places you can define a measure using the FORMAT function:

• Some details about the FORMAT function
• Simple measure could be (first section is for positive number, second for negative number, third for zeros)
  Simple Formatted Value = FORMAT(<Your Number as field or measure>, "#,##0.00;-#,##0.00;0")
  See above documentation for details.
  
• An example for a more advanced measure would be:
  
  Advanced Formatted Value =

  VAR _ValueAbs = ABS([Population Male Count Invers])

  VAR _Format = SWITCH(

      TRUE(),

      _ValueAbs <= 1E3, "#,0.00;-#,0.00",

      _ValueAbs <= 1E6, "#,0,.00 K;-#,0,.00 K",

      _ValueAbs <= 1E9, "#,0,,.00 M;-#,0,,.00 M",

      "#,0,,,.00 B;-#,0,,,.00 B"

  )

  RETURN

      IF(

          NOT ISBLANK([Population Male Count Invers]),

          FORMAT([Population Male Count Invers], _Format)

      )

   

  It depends on your needs....