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. 

manikumar34's avatar
manikumar34
Icon for Solution Sage rankSolution Sage
5 years ago

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. 🙂😊