topic When transforming a decimal measure into text the dot decimal seperator turns into comma in DAX Commands and Tips

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

OLM — Fri, 11 Aug 2023 14:28:07 GMT

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

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

Anonymous — Fri, 11 Aug 2023 07:35:38 GMT

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.

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

OLM — Fri, 11 Aug 2023 14:33:59 GMT

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