Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Barendnu
Advocate III
Advocate III

Show slicer values only if other slicer is set

Hi all,

 

I have a data table like following:

datatable.PNG

 

I have two slicers: country and region.

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

Good.PNG

 

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

notgood.png

 

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!

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

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

View solution in original post

3 REPLIES 3
v-yuta-msft
Community Support
Community Support

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
Solution Sage
Solution Sage

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

to do this.

disable the option from the format tab.delete.PNG

 

 

 

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 😞

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.