Change currency format 'XX.XXMCHF' -> 'CHF XX.XXM'

[Anonymous]

Hi everyone, I am trying to use a currency value from a measure with currency : 'CHF French (Switzerland)' In a visualization I would like to show the currency with this format : 'CHF XX.XXM' But it always show like 'XX.XXMCHF' (M is for millions that I changed in field formatting) I don't find in Measure tools the format options to change this option. Example : '12.75MCHF' but I would like to show it like this 'CHF 12.75M' Is it possible ? Thank you all ! Loveboch,

[amitchandak · Accepted solution]

@Anonymous , refer if this can help

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

[Anonymous]

Hi @amitchandak,

It worked very well, I used this 'regex' if we can call it like this : 

"CHF "#,0.00 ;"CHF "-#,0.00 ;"CHF "#,0.00 

Thank you !