Michael Shparber on 20 Nov 2024 07:50:05
I have a column that allows to switch between Currencies: USD $ or NIS ש"ח
In the Dynamic format I have a condition that returns the relevant symbol before the number shown:
VAR c = SELECTEDVALUE('Show Currency'[Currency for Calc])
RETURN
IF(c="USD","$ #,0","₪ #,0")
All works great in the Power BI but when I use Analyze in Excel - it changes the dollar sign $ to my ש"ח sign because of the Regional Settings.
I don't want to change the Regional Settings, I want to make it show exactly the symbols that I have written in the Dynamic Format.
I tried using UNICHAR:
IF(c="USD",UNICHAR(36)&" #,0",UNICHAR(8362)&" #,0")
But still the same issue.
Please help