Skip to main content
cancel
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
Comments
v-qiuyu-msft
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 

rbVG
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.

Somesh
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"

RETURN
IF
(
__Actual_Amount >= __Denomination,

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

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