To add text to a number, you'll need to first convert the number into a text field.
Converting number to text has other implications, so i would suggest creating a second (new) field, so you can use the old and new field.
(you can't sum (add up) a text field for example)
Something like that
Thanks! That worked well. Much appreciated!
You're welcome, it's a very useful trick to know
3 of 3 people found this helpful
There's another way that doesn't make you run a second calculation. Right now you have a dimension on your columns shelf, a dimension on your colours shelf, and a measure on your rows shelf. If you take a copy of your measure on your rows shelf and place it onto your labels shelf (you may already have done this) we get some additional functionality.
Now left click the labels shelf contained within the Marks Card
Then select the ellipses. From there you can simply type the unit on the end that you wish to us.
But wait there's more! You can also set the format via your axis or by default by right clicking the measure from inside the data pane, choosing 'default properries', 'number format', 'number custom' and adding a suffix.
Lots of ways to handle this by forcing the text to be a string in some cases you will find very difficult and ugly cases of rounding.