Power BI number Format

[Anonymous]

I am trying to format a number like below.

For e.g; There is a number like 1234567 (This is the result of a Measure)

I am trying  to format the above number like 1.234.567

Can anybody knows this please suggest me.

Thanks.

[mahoneypat · Accepted solution]

Here is one way to do it.  Just use the Substitue part and replace num1 with your measure.

FormatExample = var num1 = 1234567

return SUBSTITUTE(FORMAT(num1, "#_###_###"), "_", ".")

Regards,

Pat

[manikumar34]

@Anonymous , 

You can use FORMAT(Table[Column or Measure],"#.###.###") to achieve this. 

Note: Whne you use custom format with FORMAT function the numeric value will be converted to String value. Beacuse of which you cannot place this measure on charts but can be used on cards, Table and Matrix.

Regards, 

Manikumar

If you find this is helpful, Accept as a solution and Leave a like. 🙂😊

[Anonymous · Accepted solution]

Hi @Anonymous 

You can use Custom Format in Model view as well.

Here I build a measure returns to 1234567,2345678 like yours.

And select Custom in Format and use this format: #"."###"."###.

Result is as below.

Best Regards,

Rico Zhou

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

[mahoneypat · Accepted solution]

Here is one way to do it.  Just use the Substitue part and replace num1 with your measure.

FormatExample = var num1 = 1234567

return SUBSTITUTE(FORMAT(num1, "#_###_###"), "_", ".")

Regards,

Pat