Custom Number Format for the Numerical Fields in Power BI

[mpapreja]

Dear Experts

Thanks for your support in advance. 

Can i use following format in Power BI which works in excel

[>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0

[Anonymous · Accepted solution]

Hi  @mpapreja ,

Here are the steps you can follow：

1. Create calculated column.

Column =
IF([Column1]<10000000,
","&MID([Column1],LEN([Column1])-6,2)&","&MID([Column1],LEN([Column1])-4,2)&","&RIGHT([Column1],3),
LEFT([Column1],LEN([Column1])-6)&","&MID([Column1],LEN([Column1])-4,2)&","&RIGHT([Column1],3))

2. Result:

Best Regards,

Liu Yang

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

[lbendlin]

mostly yes.  

Use custom format strings in Power BI Desktop - Power BI | Microsoft Docs

You can also use FORMAT to achieve the Indian number display.

Measure = 
var yournumber = <your number here>
var twoples = ROUNDUP((LOG10(yournumber)-3)/2,0)
var fmt = REPT("##\,", twoples) & "###.00"
return FORMAT(yournumber, fmt)