Forum Discussion
Format String editing
Hi all.
I´m working a lot using Tabular Editor adding measures etc...
A problem is that I suck at writing Format Strings manually.
I´ve saved a library with recurring strings, ex #,##0.00 % for 2.23%
But I need to learn how to do this myself.
Does anyone no any good guide, tutorial, tool etc... for this?
BR Måns
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!!
3 Replies
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!!Hey Mary,
Format strings in power bi match those in excel, a good rule of thumb is get your desired outcome by working in excel using the custom format setting. Once you are happy you can then copy the format string from excel and use it in power bi
Thanks for answer ajohnso2 and rajendraongole1
