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
1 Comment
- Status added:New
Recent ideas
Preserve Power BI Semantic Model Measures and Business Metadata When Generating Fabric IQ Ontologies
When Fabric IQ generates an ontology from an existing Power BI semantic model, it should preserve more of the business semantics that organizations have already invested in defining. Today, a semant...