Forum Discussion
How to Automatically Reset Sub Category Slicer When Parent Category Changes in Power BI?
Hello Power BI Community,
I am encountering an issue with cascading slicers in my Power BI report and would appreciate your insights.
Report Setup:
- I have two slicers in my report:
- Parent Category (first slicer)
- Sub Category (second slicer, cascades based on the selection of the Parent Category)
Problem:
When I make a selection in the Sub Category slicer and then change the selection in the Parent Category slicer, the Sub Category slicer does not reset or clear the previous selection. The slicer continues to display the last selected subcategory, even though the available options might no longer be valid after the parent category changes.
Desired Behavior:
I would like the Sub Category slicer to automatically reset or clear its selection whenever a new selection is made in the Parent Category slicer, so that the user is prompted to make a new selection based on the updated list of subcategories.
Question:
Can anyone provide a solution to automatically clear or reset the cascading slicer when the parent slicer changes? I have tried various settings but haven’t found a way to achieve this behavior.
Thank you for your help!
- Anonymous1 year ago
Hi JaydeepPatel ,
You can try using HierarchySlicer as an alternative.
In it, you can select the parent hierarchy first and then expand it. The sub hierarchies inside won't contain other options, so you can be sure that you won't pick unexpected results in the sub hierarchies.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- AnonymousNot applicable
Hi JaydeepPatel ,
You can try using HierarchySlicer as an alternative.
In it, you can select the parent hierarchy first and then expand it. The sub hierarchies inside won't contain other options, so you can be sure that you won't pick unexpected results in the sub hierarchies.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- lbendlin
Super User
Not currently possible. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com