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
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Support Schema Evolution for Fabric Graph Without Rebuilding the Graph Model
Fabric Graph should support controlled schema evolution as enterprise business models change over time. Graph models are rarely static. Organizations need to add new node types, properties, relation...mourakshit56 seconds agoNew MemberNew0Views0likes0CommentsMake Fabric IQ Ontology Entities First-Class Assets in OneLake Catalog
Fabric IQ ontology entities and business concepts should be discoverable as first-class governed assets in OneLake Catalog. Today, users often need to know the underlying Fabric item, table, semanti...mourakshit3 minutes agoNew MemberNew0Views0likes0CommentsAdd Incremental and Event-Driven Refresh for Fabric IQ Ontology
Fabric IQ Ontology should support incremental and event-driven updates when the underlying source data changes. For operational and real-time scenarios, ontology entities and relationships may be ba...mourakshit5 minutes agoNew MemberNew0Views0likes0CommentsAdd Versioning, Git Integration and CI/CD for Fabric IQ Ontologies
Fabric IQ Ontology can become a shared enterprise definition of business entities, relationships, properties, and context. As ontologies become dependencies for Data Agents, Graph, applications, and ...mourakshit6 minutes agoNew MemberNew1View0likes0CommentsZoom Based Visibility for Location Labels in the Azure Maps Visual
Location labels can be helpful for maps but also create a lot of clutter when zoomed out. It would be great if zoom based visibility controls could be enabled for this feature.AllianceDA3 hours agoAdvocate IINew6Views0likes0Comments