Changing two columns on a table into various alternatives

[twofingertyper]

Hi all, 

I have a table of values that is rather long and unweildy (it goes off the edge of the report page and requires scrolling to the side, but this is what the end user wants... as much as it pains me). Anyway, essentially I have 20 variations of currency that are attached on the end of each line - I've broken these down and can group and use 20 different tables and bookmarks to move between these and enable some useful functionality on the table, but is there a better way? 

I am positive there must be?

Thanks for any pointers

[dlopesc04]

Yes, you can use field parameters to switch between specific measures, in this case one for each currency.
Alternatively you can use dynamic formatting.

[twofingertyper]

This partly works - however - I have multiple columns for the same currency (members get a discount, etc), and I'd really like a drop down where I could select GBP and get the 2 columns shown without having to make individual selections, but that seems impossible. 

[dlopesc04]

That is definitely possible though

[twofingertyper]

I kept going around in circles on Friday, as the values are stored as strings (because I want to put AUD $, USD $ in front of them instead of just a number) it didn't work as I expected. 

It may be that I could unpivot the columns (so that I get multiple rows for each product with each currency line, as opposed to one line with all currencies) and approach it from that way, but I ran out of time on Friday for what was a 'nice to have' rather than 'must have' feature.

[twofingertyper]

Interesting, I have used parameters on visuals before, but never to offer a selection on table columns - I've already done some dynamic formatting (as Power BI doesn't seem to automatically offer $ with a country attached, and there's NZ, Aus, US, etc)

Will explore further!  

[dlopesc04]

I'm pretty sure Power BI has pretty much all currencies, refer to this for the out the box currency formatting: https://community.fabric.microsoft.com/t5/Desktop/Change-the-currency-symbol/m-p/15185

Could be useful for copying the formatting string for the dynamic formatting.

[twofingertyper]

It does! But if you select $ (United States) and $ (Australia) it doesn't mark them up any different in a visual? That's why I do the dynamic formatting to add in the USD, AUD part when necessary.