dynamics list in Slicer (new)

[Moody__01]

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]

Lovely ! I generally dont like putting filter in my report but this one works well 

Thanks a lot @amitchandak for your prompt feedback & solution 🙂 

[amitchandak · Accepted solution]

@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