Adding Units

[vanquisher11]

I want to add a unit on each of my values

Desired Table

Measure 1     Values 

Profits          £500

Sales              30000

EBITDA          90%

How do I create a column/measure such that There's a unit corresponding my values?

I tried using concatenate, but numbers are transformed to text format, which is not ideal in my case.

Thank you!

Kind Regards,

Matt

[Anonymous]

Another solution would be to format your visual as a MATRIX, and then in the values section of the formatting options, check the box for "Put Measures on Rows".

That way you can put your 3 individual measures in the visual, and all of them can have their own formatting, as determined in the modeling tab.

[MFelix]

Hi @vanquisher11,

Don't know if your measures are in a single formula or using different ones, instead of concateneta you can use the FORMAT something like this:

MEASURE = FORMAT ( [Measure]; "£ ###") 

MEASURE = FORMAT ( [Measure]; "###")

MEASURE = FORMAT ( [Measure]; "###%")

Regards,

MFelix

[vanquisher11]

Hi Felix,

Thank you very much! But  my measure is on one formula.. how do I use the FORMAT function if that's teh case?

thank you!

[MFelix · Accepted solution]

Hi @vanquisher11,

You use exactly as a column:

Formated measure = FORMAT (SUM(Table[Column]), "### €")

You can do it as I place it on top calculating your measure or make a new one and use the first measure on your syntax.

Regards,

Mfelix