Custom Number format in Power Bi

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

Hi Niraj,

Have you read the documentation: Custom numeric formats for the FORMAT function? Here is a link:
https://docs.microsoft.com/en-us/dax/custom-numeric-formats-for-the-format-function

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