cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cristianml
Post Patron
Post Patron

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 Super User!




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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors