Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I would like to get a suggestion for my issue. Currently, I am receiving many documents in different reporting currencies. So my calculations are as follows:
Now I am trying to show the total amount as default in EUR, but also in USD or GBP if the right tile is being pressed or selected as:
Also, will the Pie Chart will be updated accordingly? And how could I achieve such functionality? Any tips or suggestions would be highly appreciated.
Cheers,
Matas
Solved! Go to Solution.
@Matas , A very similar topics ha been solved here, see if that can help
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
Thank you for all the suggestions.
I was able to figure it out pretty much by combining all of your provided information.
Cheers!
Change your GBP, EUR and DOL queries to a merge with the exchange rate file.
The amounts as a new base currency column eg all GBP.
Then create a Currency pick list table
Currency | Exchangerate |
GBP | 1 |
EUR | 1.19 |
DOL | 1.26 |
and this measure
GBPAmount =
SUM(Sales[GMPValue)])
Sales in currency =
VAY myexchangerate= SELECT(picklist(Exchangerate))
RETURN
[GBPAmount] * myexchangerate
The either add a slicer with the picklist(Currency)
or use the filter menu to specify the picklist(Currency) for each visual.
Drag the [Sales in currency] to your visual and it should work.
Please click thumbs up and Accepot As Solution, thank you !
Hello @Matas ,
you could use the switch function as explained here
(775) DAX Fridays! #15: SWITCH - YouTube
You will need to use explicit measures and an additional table.
Is that what you are looking for?
best
hashtag_pete
@Matas , A very similar topics ha been solved here, see if that can help
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
User | Count |
---|---|
85 | |
85 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |