Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
AnjanaTh
Frequent Visitor

Set slicer valueselected to a defalut value ,but show other values also in dropdown based on another

i have a slicer A and one another slicer B ,what I want is when I select a certain value in slicer a the slicer b selection have some default value selection to it ,but rest of the values should alos show but not selected .and when other value value of slicer a is selected no default selection should be there in slicer b .how it can be achievd in power bi ,columns of slicer a and slicer b are in the same table

5 REPLIES 5
Anonymous
Not applicable

Hi @AnjanaTh ,

 

Here is a workaround, hope it helps:
Slicer Values Don’t Clear after Changing a Second Slicer - Excelerator BI

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

I want certain values of the sub category slicer to be selected by default and rest values should also be seen in the dropdown ,but they are not selected . 

taking your example : my requirement is when in Category slicer Accessories is selected ,in Subcategory slicerbike racks and bike stands are selected by default but the rest options are still visisble in dropdown . and when i choose something else in category slicer slicer it should show the subcategory value for the selected category but nothing is selected by default

AnjanaTh
Frequent Visitor

I have a year and quarter column in a table .What my requirement is that if i selected fy24 in year slicer the quarter slicer should have some default value selected in the quarte slicer and rest value for quarter should be there in the dropdown but not selected . and when I select any other value in year slicer no value in the quarter slicer should be selected ,it should show all the values in dropdown

 

Ritaf1983
Super User
Super User

Hi @AnjanaTh 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors