May 23, 2020
I have created a dashboard in Power Pivot that is based on some 20 excel files coming from different resources. I downloaded all my data from my financial software that is in Qatari Riyal (QAR). As all the data is in QAR, obviously the dashboard is also in QAR. My boss wants to see the dashboard in USD. Now the question is if there is an easy way to convert Dashboard figures into USD (or may be to show in both currencies using Slicer) without changing the base file and queries?
If there is no solution then I have to go back to each report and add USD column using Power Query.
Thanks and advance.
September 5, 2021
I am not an expert a all but i have similar situation on my dashboards. what i did was create a table with the exchange rates i need to show and link it the information i download every month, then i build a dax measure in my excel pivot table to multiply the desired exchange rates and use that measure to show it in my dashboard.
Hope this helps