Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
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
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
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 103 | |
| 80 | |
| 62 | |
| 50 | |
| 45 |