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
julienvdc
Helper III
Helper III

Enabling slicer once other slicer was selected

Is there a way to get a slicer to be disabled (un-usable) until another slicer has been used/selected? Or pehaps hide the slicer when the other hasn't been used?

1 ACCEPTED SOLUTION

Hi @julienvdc ,

 

Select the slicer and go format -> background ->fx

vchenwuzmsft_0-1645085243128.png

Or you can let the slicer have no data when another slicer unselected.

 

create a measure like the following:

F_month = IF(ISFILTERED('Table'[year]),1,0)

And put the measure in the filter pane of month slicer and set the item is 1, apply the filter.

vchenwuzmsft_1-1645086270270.png

if unselect year, there no month in the month slicer.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

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

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@julienvdc ,  You have the option to have a transparent color. But item color does not have a conditional formatting

option

 

Also overlapping card will not work.

We usually create these type measure and use transparent color and opposite of it to create such

 

IF(ISFILTERED(Table[ID]),"White","#FFFFFF00")


IF(ISFILTERED(Table[ID]) && hasonevalue(Table[ID]),"White" ,"#FFFFFF00")


IF(ISFILTERED(Table[ID]) && hasonevalue(Table[ID]) && max(Table[ID]) =1,"White" ,"#FFFFFF00")

Hey @amitchandak thanks for your reply 😉

(basically I want my users to be using the slicers in a specific order)

I am just not sure where you suggest I should be using/placing these measures?

I was wondering if with the bookmark/selection pane dynamic I could achieve this?

Hi @julienvdc ,

 

Select the slicer and go format -> background ->fx

vchenwuzmsft_0-1645085243128.png

Or you can let the slicer have no data when another slicer unselected.

 

create a measure like the following:

F_month = IF(ISFILTERED('Table'[year]),1,0)

And put the measure in the filter pane of month slicer and set the item is 1, apply the filter.

vchenwuzmsft_1-1645086270270.png

if unselect year, there no month in the month slicer.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

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

Hey @v-chenwuz-msft the second solution with the filter works great!

 

I did not however understand the first option; the one playing with the background colour. If you have time at some point, I'd be curious to see what it is 🙂

 

Thanks for the help!

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.