Slicer values update on another slicer selection

[arimoldi]

Hi,

in a page I have two slicer, one related to categories and another related to sub-categories, so that when I select a category with slicer #1 I can see the related sub-categories in slicer #2.

The problem is that when I change the category in slicer #1, the slicer #2 still have the assignation of the previous sub-category which does not exists in the new category selected in sliceer #1, so when I change category I have a blank page and I have to manually re assiign the sub-category with slicer #2.

Is there a way to make the sliceer #2 suto-select a valid value based on the slicer #1?

Thanks,

Andrea

[Anonymous · Accepted solution]

Hi @arimoldi 

The Power BI slicers themselves do not support automatic selection of values in one slicer based on the selection of values in another slicer.

Instead of using two separate slicers for categories and subcategories, you can create hierarchies that combine these fields in the data model.

The data might look something like this:

Then, use a slicer based on this hierarchy. This way, as users select categories, they can drill down to select subcategories in the slicer.

This approach ensures that subcategories are always relevant to the selected category.

You might also consider building slicers with a hierarchical structure.

Add multiple fields to a hierarchy slicer - Power BI | Microsoft Learn

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.