cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Dynamically set maximum slicer value based on other slicer

Requirement is to preselect slicer 2 maximum value based on slicer 1 selection. Could you help me for possible option to achieve below output in slicer 2

Slicer 1 (S Name)

Expected output in Slicer 2 (Sub Type):

Slicer Selection2.PNGSlicer Selection.PNG

 

Table:

S NameSub Type
S1S11
S1S12
S1S13
S2S21
S2S22
S3P31
S441
S442
1 REPLY 1
Super User III
Super User III

@Anonymous there is no functionality to have default selection in slicer. I think there is an idea for this feature, may be you want to vote it. At this point I don;t think out of the box slicer will work but you can check at market place slicer if that get to achieve what you are looking for. 






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

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

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors