Format String editing

[Anonymous]

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

[Anonymous]

Thanks for answer @ajohnso2  and @rajendraongole1 

[ajohnso2]

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

[rajendraongole1 · Accepted solution]

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!!