currency management + dynamic currency symbol

[Anonymous]

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

[v-cherch-msft · Accepted 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,