undefined

Question

I have one AUD column for "Revenue" in the data. I will add another column in USD, now I need a slicer that turns the ENTIRE dashboard either into AUD or USD.&nbsp;How would I do that?

tackytechtom · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Might this one here help you out?
https://www.tackytech.blog/how-to-get-the-latest-exchange-rates-straight-into-power-bi/
&nbsp;
Let me know!
&nbsp;
/Tomhttps://www.tackytech.blog/https://www.instagram.com/tackytechtom/
&nbsp;

anonymous · Answer

Hi,Thanks for your response. I am using a fixed rate for USD, so I will create a new measure for USD Revenue. Now the issue is instead of making 2 separate tabs of AUD and USD dashboard, I want to create a dashboard with a single click (selecting from slicer) that will get either in AUD or USD.

tackytechtom · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
For that, I'd probably go for calculation groups.
&nbsp;
Here a link that explains the concept of it:
Calculation Groups in Power BI - Data Bear
&nbsp;
Let me know, if this helps 🙂
&nbsp;
/Tomhttps://www.tackytech.blog/https://www.instagram.com/tackytechtom/

Forum Discussion

undefined

3 Replies

Related content

undefined

undefined

undefined

undefined

undefined