Add a letter onto end of value

[Anonymous]

Hi All,

Just a quick question - is there a simple way to add a letter or letters onto the end of a measure value?  Of course, the reporting needs would love it if my measure when presenting in my visual would show say 50.45 with an z on the end, and in another case an x.  So the number would appear in the visual as 50.45z.  It doesn't represent a monetary value like thousands or anything like that - its their own designation.  I was curious if there was some easy way to take the measure say Measure1 and just add an z onto the end of the result.  I think I could just create a new table and add in a column of z's or x's and then just concatenate but was curious before I did all that if there was some simple way to just say Measure2 = take Measure1 and add z - in dax language of course. 

Thanks - YB

[mwegener · Accepted solution]

Hi @Anonymous ,

check this... 

Use custom format strings in Power BI

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

https://blog.crossjoin.co.uk/2019/09/11/power-bi-custom-format-string-examples-part-1-numbers/

[Anonymous]

@mwegener ,

Jeez that is soooooo friggin easy... thanks man!!  That works for all visuals, etc.

-YB

[amitchandak]

@Anonymous ,

Not sure I got it.

But you can always append some letter at the end of measure

measure =[measure] & "Z"

But this makes it text. So you need to take care of formatting in formula

Refer :https://www.youtube.com/watch?v=Z9HNYx-b7ro

[Anonymous]

Thanks @amitchandak  - yeah even if I did the table way and used concatenate it would become text.  How would I append it in the forumla?  It should always be a small number like 5.4z or 1.2x, etc.  It will be used in cards and simple bar graphs.

[amitchandak]

@Anonymous ,

Can you share sample data and sample output.

[Anonymous]

@amitchandak 

So to your point - when I said [Measure]&"Z" the result is a text values that now instead of saying example 1.2z is now saying 1.22667545z .  When I go to the formatting section all the decimal/value places are greyed out.  How can I shrink that down?

[Anonymous]

@amitchandak  I need this shrunk down and in a number format somehow as this text field is unusable in a graph.   Now i'm thinking even if I used my suggested way of throwing the values into a table and creating a row of x's and used concatenate that also would not work as the result would be text as well.  It would work for a simple card visual but  not in a graph.  How can I use your simple measure and turn it into a decimal value?

[v-gizhi-msft]

Hi,

I think once you add character to the original decimal or whole number format data, it will be converted to text format automatically.

You can change its display units to add character at the end of number data.

 

Like this:

The data is still the number format not text.

Hope this helps.

Best Regards,

Giotto