Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
We are trying to have one report with option to switch from US version to UK one, by changing currency symbol in visuals.
currency symbol is part if the main fact table.
I did look online and all videos i came across are about currency conversion. We are creating a template of the report to which US or UK team can
import their own data from their own dataset, so we don't need conversion of currency from $ to £ using currency rate. We just need to be able to reformat currency symbol
from £ to $ quickly without re-formatting all of our DAX.(We are using same DAX measure for both US and UK reports).
Thank you for help
Have you tried using a calculation group? The article below discusses how they can be used to control currency symbols. Look at the section on Format String Expression.
https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/
Proud to be a Super User!