When transforming a decimal measure into text the dot decimal seperator turns into comma

[OLM]

I have a measure that returns a decimal format "0.0"

For a card I require to report it side by side with another measure using a text format

= [Decimal measure A ] && "/" [Decomal measure B]

It results both decimal measures seperators to turn from a dot to a comma. 

Using the format function also did not work: = Format( [Decimal measure A ], "0.0") && "/" Format([Decimal measure B] "0.0")

Regional setting are fixed for US English.

Your help appreciated.

Thank you,

Liam

[Anonymous]

Hi  @OLM ,

You can try the following dax:

Flag =
FORMAT([Decimal measure A],"$#,#.0") &"/"&FORMAT( [Decomal measure B] ,"$#,#.0")

If it doesn't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[OLM]

Thank you for the quick response. I will give it a try on monday but as I put it in the question is exactly what it is, nothing should influence it aside from the PBI settings. Due to privacy, I cannot share the file.

KR,

Liam