Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Anonymous
Not applicable

Dynamic slicer selection

‎07-30-2018 11:49 AM

Is it possible to have 2 slicers or many slicers in a page but can only filter based on 1 slicer at a time. I have 2 slicers and i have to make sure either 1st or 2nd slicer can be used at a time. If i have made a selection in 1st slicer then 2nd should select all and vice versa.

Message 1 of 3
1,298 Views
0
1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

‎07-30-2018 12:53 PM

Possibly, can you provide some sample/example data and expected output. I have done a lot of tricky things with slicers to manipulate their default behavior. I don't think any of these do exactly what you want but they may give you ideas:

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort/m-p/391883

https://community.powerbi.com/t5/Quick-Measures-Gallery/In-Common/m-p/382956

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Not-In-Common/m-p/388273

 

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Message 2 of 3
1,306 Views
2 REPLIES 2
Greg_Deckler
Super User
Super User

‎07-30-2018 12:53 PM

Possibly, can you provide some sample/example data and expected output. I have done a lot of tricky things with slicers to manipulate their default behavior. I don't think any of these do exactly what you want but they may give you ideas:

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort/m-p/391883

https://community.powerbi.com/t5/Quick-Measures-Gallery/In-Common/m-p/382956

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Not-In-Common/m-p/388273

 

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 3
1,307 Views
Anonymous
Not applicable
In response to Greg_Deckler

‎08-14-2018 04:32 AM

Thanks for the help Greg, Though the requirements changed slightly i got some great ideas from the links below.

Message 3 of 3
1,268 Views
0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

View All