Format String editing

Hi Anonymous - Creating and using custom format strings in Power BI, particularly when using Tabular Editor, can be challenging at first, but with the right resources and practice, you can get proficient at it.

Reference links:

Standard numeric format strings - .NET | Microsoft Learn

Custom numeric format strings - .NET | Microsoft Learn

Standard date and time format strings - .NET | Microsoft Learn

Custom date and time format strings - .NET | Microsoft Learn

Examples:

Currency:

$#,##0.00: Displays as currency with two decimal places (e.g., $1,234.56).

Percentage:

0%: Displays as percentage without decimal places (e.g., 50%).
0.00%: Displays as percentage with two decimal places (e.g., 50.00%).
Numbers:

0: Displays as an integer (e.g., 1234).
0.00: Displays with two decimal places (e.g., 1234.56).
#,##0: Displays with thousand separators (e.g., 1,234).

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!