What is this format string?

[Anonymous]

I have a measure with this Format string.

Format: Custom

Foormat String: #,##0.00;-#,##0.00;0.00

I dont understand what the ;   does... Also, are the # wildcards?

[Tahreem24]

@Anonymous, Just for the clarification take any list of values (with different sample of digits) and apply that mentioned formatting on new calculated column. Attached SS for your reference:

New Calculated Column  =  FORMAT(Tbl2[Value],"#,##0.00;-#,##0.00;0.00")

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

For your confusion, A format expression for strings can have one section or two sections separated by a semicolon (;)

"#" is a form of User-defined numeric formats.

If you still have problems, please point out. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous I think ; is for more than one format. # is for number

refer the below part of blog

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