Show slicer values only if other slicer is set

[Barendnu]

Hi all,

I have a data table like following:

I have two slicers: country and region.

When you select a country, the region slicer nicely shows only the regions in that specific country:

But when you select all countries, the region slicers shows all regions of all counties:

We received a request to only show the (items in the) region slicer once a country has been selected.

Would this be possible?

Thank you in advance for your help!

[v-yuta-msft · Accepted solution]

Hi Barendnu,

I'm afraid Built-in slicer can't meet your requirement, have you tried hierarchy slicer? https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview.

Regards,

Jimmy Tao

[rocky09]

May be you you Hide "Select All" Option from the First Filter.

to do this.

disable the option from the format tab.

[Barendnu]

Hi Rocky09, thank you for the suggestion! Unfortunately, the client indicates that that is not an option, because they want to keep the overall view 😞