Create a currency parameter

[Anonymous]

My database has information in two different currencies and I want to create a parameter in the dashboard for showing the data in a specific currency.

I want to make the conversion from one currency to another with a SQL query.

Example:

The data is on CLP and USD currencies.

If I choose CLP, all the data that is on USD will be converted to CLP and showed in CLP.

If I choose USD, all the data that is on CLP will be converted to USD and showed in USD.

Third option to show data on its original currency.

How can it be done?

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may have a look at below post to check if it could help you.If you need further help,please share some sample data and expected output which would be helpful to provide an accurate solution.You can also upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

https://community.powerbi.com/t5/Desktop/Convert-Currency-Conversion-with-Slicer/m-p/624633/highlight/false#M298341

Regards,

[v-cherch-msft]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

Regards,