The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?