Forum Discussion
Anonymous
3 years agoNot applicable
undefined
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
3 years agoNot applicable
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
3 years agoMost Valuable Professional
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/