Alternating Currencies

[CBoardy]

Hi All,

I'm in the process of creating an APP but I need the sheets inside the app to be able to switch between two currencies, ie USD and GBP.

I was thinking of creating a switch or a button of some sorts for this but I don't know how this can be done.

Is it possible to duplicate all the sheets and have two sets of sheets, one in USD and other in GBP. Then when someone presses the button/switch all the USD sheets hide and they can only see the sheets in GBP, and vice versa?

Any help would be greatly appreciated

[Or · Accepted solution]

Either approach is possible. You can use a show/hide condition at the sheet level, or you can create measures that automatically switch based on the currency selection, e.g. Sum(If(Currency = 'USD',[Sales USD],[Sales GBP]))

[CBoardy]

I have decided to go the show/hide direction. I'm hoping to create a switch I can put on every sheet that can alternate the hidden sheets. I've been trying to use vizlib switch but have had no success, is this possible?

[Gabbar]

You can try using variable input and using pick match in set expression at appropriate places.

[CBoardy]

Thanks for your help but I went with the first comment