Hi, the following DAX formula in Card visualization has problem with CAD currency. Or let say with "C" and "D" character.
According to your sample pictures, I can’t really understand where’s your existing issue, would you like to expalin it in detail?
Community Support Team _Robert Qin
Hi, Please let me know whether the shared files make it clear.
Hi, when the currency is CAD the following formula can not display the C$ symbol!
Hi again, even the following formula does not make it correct!
I have reported this issue internally, ICM: 268199699
I will update here once I get any information.
I’ve got this message from pg:
the first C in "C$#,##0.##" is a reserved letter in the string function AS uses (VarTokenizeFormatString ) indicating the input is of a calendar format, correct way of setting currency is escaping it like: "\C$#,##0.##", fixed pbix file attached.
And below is a download link of the attached pbix file from pg:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.