Change Slicer option based on other Slicer

[cristianml]

Hi,

How can I change the "Currency" by selecting from other Slicer the two options I have like the following print ? 

Note:  Each currency is related according to each "Location" in Table. The idea is to have only the "US Dollar / Local Currency" Slicer and remove the "Currency" one: 

Thanks,

Regards,

[PattemManohar]

@cristianml  I guess, you are looking to capture the slicer value and populate in the Table visual based on the selected value in the slicer. If that is the case then create a measure and use that in the table visual

Test255SelectCurrency = SELECTEDVALUE(Test255Selection[Currency])

[cristianml · Accepted solution]

Hi @PattemManohar ,

Finally I solved the problem by creating a new Column in each data table (in my case I have 7 tables) and concatenate the Location + the currency and then create a Table to map this with the currency type (local currency or Dollar). Then I create another column with "lookupValue" to get the currency type in a new Column and use this with the Slicer. 🙂

Thanks !