Forum Discussion
Helper ICurrency Slicer
Hi there!
I am building a sales revenue dashboard will be viewed on zone management level for many countries.
Therefore I need to add a filter with the currency. But I already have columns for the revenue in different currency,
ex('Revenue_Local Currency' , 'Revenue_Global Currency')eta.
How can I add a slicer that enables the user to change the currency in the tables and charts upon these tables? or you advise using an other easer way?
Thanks a lot in advance.
1 Reply
- amitchandak
Super User
Hadill , we usually have data in local and global currency and all our measure use switch the value based on an independent slicer of currency to local to global
refer other examples
currency
https://www.youtube.com/watch?v=4dosxfNxR6M
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
https://radacad.com/currency-converter-power-bi-function-part-1
https://www.youtube.com/watch?v=Q4hF4CwJsFEhttps://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2
https://businessintelligist.com/2015/03/17/power-bi-tutorial-how-to-implement-currency-conversion-using-power-query-and-power-pivot/
https://blog.beyondimpactllc.com/blog/building-a-dynamic-currency-converter-with-power-bi
