cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaouad Frequent Visitor
Frequent Visitor

Add units

Hi,

 

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

 

Thanks for you support.

 

Regards,

 

Jaouad

ton

1 ACCEPTED SOLUTION

Accepted Solutions
jaouad Frequent Visitor
Frequent Visitor

Re: Add units

Dear Victor,

 

Thank you for your help !!

 

Regards,

 

Jaouad

 

7 REPLIES 7
BhaveshPatel Super Contributor
Super Contributor

Re: Add units

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

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
jaouad Frequent Visitor
Frequent Visitor

Re: Add units

Dear Bhavesh,

 

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

 

Please check the picture below :

 

ton.jpg

 

 

Thanks for your support,

 

Jaouad

BhaveshPatel Super Contributor
Super Contributor

Re: Add units

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.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
jaouad Frequent Visitor
Frequent Visitor

Re: Add units

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 Super Contributor
Super Contributor

Re: Add units

@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.




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




jaouad Frequent Visitor
Frequent Visitor

Re: Add units

Dear Victor,

 

Thank you for your help !!

 

Regards,

 

Jaouad

 

rikBI Regular Visitor
Regular Visitor

Re: Add units

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 26 members 916 guests
Please welcome our newest community members: