Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
Lovely ! I generally dont like putting filter in my report but this one works well
Thanks a lot @amitchandak for your prompt feedback & 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
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
54 |