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

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

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

Top Solution Authors
Top Kudoed Authors