Hi everyone,
This is regarding implementing multiple currencies in the dashboard - I’m aware that there are some posts already but some have a QVW file attached as solution and since I use my company laptop, neither can I download them nor provide screenshots.
However, I’ll try my best to explain the situation and I’ll be glad if any of you could help by writing a few codes or screenshots.
I am working on a dashboard that shows Actuals vs Budget for many countries.
Table A has most of the data such as date, month, year, actual, budget, country, currency code, currency symbol, etc.
Table B has currency code, closing rate, etc.
Above tables are joined by Currency Code and Month, Year. There is a synthetic key as a result but that’s not affecting my dashboard at the moment as my formula is accurate and results match with source data.
What I want?
With each country/currency selection a user makes, the values in the dashboard changes along with the respective currency symbol (base view should be GBP).
What I’ve tried already?
1. GetPossibleCount
2. Creating variables for currency symbol such as only([Currency_Symbol]) in the front end as well as back end and then incorporating them in my formula
3. Commented out SET Money Format in the auto generated code section in DLE
4. Set Number Formatting in the KPI to Measure expression.
Nothing has given me a full proof solution.
Please help if possible.
