- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Change Slicer option based on other Slicer
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,
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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])
Did I answer your question? Mark my post as a solution!
Proud to be a PBI Community Champion
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 !

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-08-2024 12:36 AM | |||
10-07-2024 03:00 AM | |||
10-30-2024 07:52 AM | |||
09-18-2024 12:19 AM | |||
04-29-2024 07:17 PM |
User | Count |
---|---|
137 | |
107 | |
84 | |
60 | |
46 |