Forum Discussion

JaydeepPatel's avatar
JaydeepPatel
Frequent Visitor
2 years ago
Solved

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 Ca...
Need Help
  • Anonymous's avatar
    Anonymous
    1 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.

Anonymous's avatar
Anonymous
Not applicable
1 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.