cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
obaur Frequent Visitor
Frequent Visitor

Show numbers in either local currency or $ based on parameter

I have a simple table I use. In this table I have 2 fields with amounts. one in local Currency and one in $. I'd like to use now a parameter with which the user can select in which currency the charts are shown.

How can this be done?

Regards,

Oliver

3 REPLIES 3
Super User
Super User

Re: Show numbers in either local currency or $ based on parameter

Hello @obaur,

 

you can achieve this by adding an extra table to your model (not connected to any other table) where you would have two rows (Show Amount in USD, Show Amount in Local)

 

afterwards you would add a slicer linked to this table where the user can select either Show Amount in USD or Show Amount in Local

 

then you would adjust your measure to take into consideration the selection of the user

 

=

IF(SELECTEDVALUE(YourNewTable[YourNewColumn]) = "Show Amount in USD", [Your USD measure], [Your Local Measure] ))

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

obaur Frequent Visitor
Frequent Visitor

Re: Show numbers in either local currency or $ based on parameter

Very good feedback thanks. I will try this.

 

Community Support Team
Community Support Team

Re: Show numbers in either local currency or $ based on parameter

Hi @obaur ,

 

Have you solved your problem?

 

If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please feel free to ask.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.