Custom Number format in Power Bi

Power BI
1

Hello Everyone,

I have a custom number format as below taken from excel.

(* #,##0.0"Pts");(* (#,##0.0"Pts");(* “-”??);(@_) which is converted to (7.2 pts) for -7.2, 8.836912754 as 8.8 pts and so on.

I would like to implement this in power bi and written a measure as below:

=Format(mynumer, (* #,##0.0"Pts");(* (#,##0.0"Pts");(* “-”??);(@_)). But it’s not working.

Any help on this is greatly appreciated.

with regards,
Niraj

2

Hi Niraj,

Have you read the documentation: Custom numeric formats for the FORMAT function? Here is a link:

But mayby you don’t need the FORMAT function at all… Custom formatting is relatively new to power bi and there are differences to for example Excel. But this article will give you some ideas.

2 Likes