Forum, Tips & Tricks

Learn tips and tricks and engage in discussions with our blog authors here. It’s all for your benefit and learning. 

You need to log in to create posts and topics.

Advanced field formatting - custom format

Issue: Power BI tend to use scientific format on very small numbers or very big numbers

Example: 1.5554E-43

 

Solution:

  • Set custom format (see uploaded file)
  • Useful format for decimal number:  0.00;-0.00

 

Sources: https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

Uploaded files:
  • mva.png