Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Show amount Crores and Lakhs (India format)

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. 

Status: New
Community Support

Hi @yatinpurohit,


What do you mean about "Crores and Lakhs"? 


Would you please share some screenshots to clarify the issue? 


Best Regards,
Qiuyun Yu 

New Member

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.

New Member

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"

__Actual_Amount >= __Denomination,