Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Power BI community,
Is there a way to use the currency symbols (in the modelling tab) dynamically?
I have a table here with my sales in conso currency and in local currency. i want to add a slicer to select if i want to see the data in conso or local currency.
For exemple if i select "Euro" i want to see € 91,34 or if i select "USD", i want to see 112,65€ (cf. table below).
Is there any way to do this?
Sales in conso currency | Conso currency | Sales in Local currency | Local currency |
91,34 | EUR | 112,65 | USD |
11,75 | EUR | 11,75 | EUR |
51,23 | EUR | 51,23 | EUR |
59,62 | EUR | 73,03 | USD |
59,22 | EUR | 73,03 | USD |
14,53 | EUR | 59,98 | PLN |
113,48 | EUR | 139, | USD |
72,68 | EUR | 300, | PLN |
70,18 | EUR | 70,18 | EUR |
2,81 | EUR | 2,81 | EUR |
89,43 | EUR | 89,43 | EUR |
32,88 | EUR | 32,88 | EUR |
28,07 | EUR | 28,07 | EUR |
50,12 | EUR | 5 908,98 | RSD |
1,78 | EUR | 210, | RSD |
22,94 | EUR | 28,1 | USD |
11,81 | EUR | 54,89 | RON |
Solved! Go to Solution.
Hi @Anonymous
If you want to use currency symbols dynamically.You may try to create a measure with Format function like this article.You may use 'Unpivot columns' for your data to get the slicers in query editor.Please refer to attached file.
Regards,
Hi @Anonymous
If you want to use currency symbols dynamically.You may try to create a measure with Format function like this article.You may use 'Unpivot columns' for your data to get the slicers in query editor.Please refer to attached file.
Regards,