Show amount Crores and Lakhs (India format)

[yatinpurohit]

How to diplay amounts / numbers in Crores and Lakhs? I have configured a numeric field in the Power BI Desktop under Modeling tab -> Properties -> Format: Rs. English (India). It displays correctly. After I publish the report, comma gets set to Millions in Power BI web interface. My Windows 10 Region ->  digit grouping and currency settings are also correct. 

[v-qiuyu-msft]

Hi @yatinpurohit,

What do you mean about "Crores and Lakhs"? 

Would you please share some screenshots to clarify the issue? 

Best Regards,
Qiuyun Yu 

[rbVG]

1 CRORE = 1,00,00,000; (10^7 or 10 Million)
1 LAKH = 1,00,000 (10^5 or 0.1 Million)

need formating options for data lables to be in thousands, lakhs and crores instead of thousands, million and billion.

[Somesh]

DAX for reformating a Measure to represent INR(Indian Rupe) as the Currency Amount in Lakh  

Amount (INR) =

VAR __Actual_Amount = [Amount (Unformated)]
VAR __Denomination = 100000
VAR __Unit = " Lak"

RETURN
IF
(
__Actual_Amount >= __Denomination,

CONCATENATE
(CONVERT(FORMAT((__Actual_Amount/__Denomination),"₹#,#0.00"),STRING),__Unit)
,

CONVERT(FORMAT(__Actual_Amount,"₹#,##,##0"),STRING)
)