Forum Discussion
iBusinessBI
Kudo Collector
Kudo CollectorDynamic Format of a measure displays wrong result when using Analyze 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 = SELECTEDVALU...
Hi, iBusinessBI
Thanks for Poojara_D12's reply. Trying to replicate your situation, but PBI doesn't seem to support dynamically formatting currency symbols and retaining them in numeric format, how did you achieve this effect in PBI desktop, can you provide pbix/tables with no sensitive data for test.
Best Regards,
Yang
Community Support Team