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 problem with Currency update in slicer.
Problem statement is: I have data for GBUs like AU,NZ and UI in AUD, NZD and USD and FX currency slicer(AUD,NZD,USD and EURO) how with the help of dax can i dynamically convert it to one selected currency by user?
Attached is the sample PBI.
Hi @Anonymous - in your measure try using
SELECTEDVALUE(Conversion[value])
instead of
MIN(Conversion[Value])
Hope this helps
David
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
14 | |
9 | |
7 |