Reply
cristianml
Post Prodigy
Post Prodigy

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: 

Currency.png

 

Thanks,

 

Regards,

1 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 !  

View solution in original post

2 REPLIES 2
PattemManohar
Community Champion
Community Champion

@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])

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




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 !  

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)