Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I am able to show the amount in lakhs with the help of Dax measure. but it only works for score card and Table. to show that in bar chart not able to show automatically values in crore and lakhs. can anyone help me to add that lakhs and crore optionin display unit so that all the values got automated.
Thank You.
DAX for reformating a Measure to represent INR(Indian Rupe) 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)
)
@AnjaliBagwe Use Display units of None?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 10 | |
| 9 | |
| 6 | |
| 3 | |
| 3 |