Forum Discussion
Helper Idynamics list in Slicer (new)
Hi All,
I'm trying to get build up a new slicer with 2 values only-
One is hard-coded USD [Based currency of my report] while the second one would be the currency of the selected items.
while the other one would be the original currency of my selected item. in the below example, my loan is in EURO.
I would like to get a slicer allowing me to either display the value in original currency, or in usd equivalent, so only option 1&2 to be displayed.
do you guys have any ideas ? it looks like its not doable but i dont lost any hope.
Thanks & regards, Olivier
Moody__01 ,Make sure you have disconnected table with all currency code
Create a measure like
countrows(filter( CurrencyNew, CurrencyNew[Currencycode] in union(Values(Table[Currencycode]), {"USD"} ) ) )
Use this measure in slicer of that disconnected table and you use values of CurrencyNew in measure to filter data
2 Replies
- amitchandak
Super User
Moody__01 ,Make sure you have disconnected table with all currency code
Create a measure like
countrows(filter( CurrencyNew, CurrencyNew[Currencycode] in union(Values(Table[Currencycode]), {"USD"} ) ) )
Use this measure in slicer of that disconnected table and you use values of CurrencyNew in measure to filter data
Moody__01Lovely ! I generally dont like putting filter in my report but this one works well
Thanks a lot amitchandak for your prompt feedback & solution 🙂