Add units

[jaouad]

Hi,

I would like to add "tons" unit in the column quantity.

Thanks for you support.

Regards,

Jaouad

[gmckinnon]

This is a old post, but I have found a solution that works for me. 

If you go to the "Model" tab and click the measure you can add a custom text field like "tons" as below.

Then use this measure will now show the unit of measument. 

[BhaveshPatel]

Can you please elaborate it further. Your question does not make any sense.

[jaouad]

Dear Bhavesh,

In the dashboard, I would like to add units like "tons".

Please check the picture below :

Thanks for your support,

Jaouad

[BhaveshPatel]

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.

[jaouad]

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,

Jaouad

[Vvelarde]

@jaouad

Add in your measure the Word "Tons"

Like this:

ValueTons = CALCULATE(SUM(Table2[Value]) & " Tons")

Replace the table and columns accord to your data.

[rikBI]

This doesn't work for us. If we add the  & "Tons" - Part the chart is empty

[jaouad · Accepted solution]

Dear Victor,

Thank you for your help !!

Regards,

Jaouad