undefined

[Anonymous]

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.

How would I do that?

[Anonymous]

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]

Hi @Anonymous ,

For that, I'd probably go for calculation groups.

Here a link that explains the concept of it:

Calculation Groups in Power BI - Data Bear

Let me know, if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[tackytechtom]

Hi @Anonymous ,

Might this one here help you out?

https://www.tackytech.blog/how-to-get-the-latest-exchange-rates-straight-into-power-bi/

Let me know!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/