Forum Discussion
Helper IIIChanging two columns on a table into various alternatives
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
7 Replies
dlopesc04Resolver II
Yes, 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
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