Forum Discussion
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!!
Super UserHi 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!!