The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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!
Very good feedback thanks. I will try this.
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