Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I would like to add "tons" unit in the column quantity.
Thanks for you support.
Regards,
Jaouad
Solved! Go to Solution.
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.
Can you please elaborate it further. Your question does not make any sense.
Dear Bhavesh,
In the dashboard, I would like to add units like "tons".
Please check the picture below :
Thanks for your support,
Jaouad
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,
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.
This doesn't work for us. If we add the & "Tons" - Part the chart is empty
Dear Victor,
Thank you for your help !!
Regards,
Jaouad
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |