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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 |