The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?