I would like to add "tons" unit in the column quantity.
Thanks for you support.
Go to Solution.
Thank you for your help !!
Can you please elaborate it further. Your question does not make any sense.
In the dashboard, I would like to add units like "tons".
Please check the picture below :
Thanks for your support,
For this, You need to convert your net weights to tons using DIVIDE function. There is no auto settings for this.
To do this,
Create below Measure,
Tons:=DIVIDE(Sum(Table1[NET WEIGHT]), 0.00110231,2)
This will give you the expected results.
Sorry, the values are already in tons. No calculation needed.
I want to add "tons" like "$" after or before the values.
For example : 1 000 tons, 1 000 $, 1 000 €...
I don't know where we can personalize the values in the dashboard.
Thanks & regards,
Add in your measure the Word "Tons"
ValueTons = CALCULATE(SUM(Table2[Value]) & " Tons")
Replace the table and columns accord to your data.
Proud to be a Datanaut!
This doesn't work for us. If we add the & "Tons" - Part the chart is empty
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!