Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I'm facing an issue with slicer selections. I have three slicers, first one is the year slicer, the second one is where users can choose which periods they want to track, by months or by weeks, and the third one contains values for month/week selection. The idea is to show values for the certain period if chosen in third slicer (in the first screenshot), otherwise show values for the whole year (in the second).
This works fine until I want to change months to weeks. When I select week in second slicer, if the third slicer was selected it still has the value (in this case, some month). So all values in visuals show as blanks which is expected behaviour. Same happens when changing year.
Is there any way to clear slicer when the other slicer is changed? This is really confusing for users to see blanks (and irritating for me :/)
Any help is appreciated!
Solved! Go to Solution.
@m_aa There's no way to clear a slicer when another slicer changes. You could try hierarchical slicer but not sure that will meet your bespoke requirements. https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-slicer-hierarchy-multiple-fields
Alternatively, you could add a button that says 'Clear slicers' or something more meaningful and this will reset the slicers to default. If you choose this option, create a bookmark for SELECTED VISUALS and select the slicers you want to clear. Ensure only the 'data' is selected for the bookmark. Update the bookmark while selecting all slicers you want cleared on the page. https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power_11.html
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@m_aa There's no way to clear a slicer when another slicer changes. You could try hierarchical slicer but not sure that will meet your bespoke requirements. https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-slicer-hierarchy-multiple-fields
Alternatively, you could add a button that says 'Clear slicers' or something more meaningful and this will reset the slicers to default. If you choose this option, create a bookmark for SELECTED VISUALS and select the slicers you want to clear. Ensure only the 'data' is selected for the bookmark. Update the bookmark while selecting all slicers you want cleared on the page. https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power_11.html
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |