Forum Discussion
Helper IIIChanging two columns on a table into various alternatives
Resolver IIYes, you can use field parameters to switch between specific measures, in this case one for each currency.
Alternatively you can use dynamic formatting.
twofingertyperInteresting, 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.
- 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.