Forum Discussion
What is this format string?
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?
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.
3 Replies
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
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.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")
