- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Dynamic Measure Format not working right in Excel
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
-
pacifist
on: Power BI | Enable or Disable all datasets Refreshe...
- MarkB63 on: Page-Level security in reports
- Matt_Benham on: Increase pipeline max activities + fix lakehouse d...
- leyre on: Multi-window support for Power Bi Desktop
- JaydeHm on: Visual Suggestions
- Thomas_Pouliot on: Enhance Paginated Report Settings Flexibility - Pa...
- chadrenstrom on: Backup of data warehousing
- aniket_yamle on: Feature Request: Freezable Canvas Header for Power...
- JulieBABI on: Power BI Folder Management
- TBBD on: Fix 'Fabric Ideas' pages
- New 14,809
- Need Clarification 1
- Needs Votes 22,606
- Under Review 609
- Planned 252
- Completed 1,641
- Declined 217
-
Power BI
38,560 -
Fabric platform
525 -
Data Factory
438 -
Data Factory | Data Pipeline
269 -
Data Engineering
237 -
Data Warehouse
172 -
Data Factory | Dataflow
136 -
Real-Time Intelligence
126 -
Fabric platform | OneLake
104 -
Fabric platform | Workspaces
101 -
Fabric platform | Admin
96 -
Fabric platform | CICD
74 -
Fabric platform | Capacities
65 -
Real-Time Intelligence | Eventhouse and KQL
57 -
Real-Time Intelligence | Activator
50 -
Data Science
41 -
Fabric platform | Security
39 -
Data Factory | Mirroring
36 -
Fabric platform | Governance
34 -
Real-Time Intelligence | Eventstream
30 -
Fabric platform | Support
27 -
Fabric platform | Data hub
26 -
Databases | SQL Database
22 -
Databases
18 -
Data Factory | Apache Airflow Job
3 -
Product
2 -
Real-Time Hub
1