Power BI change Report Numbers to another currency

[arumel]

Hi all,

Seeking some help.

I have a report that is showing visuals in USD, the source data numbers are all in USD - some users would like to see all the visuals in the local currency also.

Is there a way to have a slicer option they can click to switch between USD or local currency (the exhcnage rate is fixed, so i dont have a issue with changing rates).

Thanks in advance

[ryan_mayu · Accepted solution]

you can create a new table and contains two value: USD and local

and use this column as a filter

and create measures like below

Measure = if(SELECTEDVALUE('Table (2)'[currency])="USD",SUM('Table'[value]),IF(SELECTEDVALUE('Table (2)'[currency])="local",sum('Table'[value])/2))

[arumel]

Thanks for your help

[ryan_mayu]

you are welcome