Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power BI number Format

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 kno...
Need Help
Tips and Tricks
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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
  • Anonymous's avatar
    Anonymous
    5 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.