Enabling slicer once other slicer was selected

[julienvdc]

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?

[amitchandak]

@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")

[julienvdc]

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?

[v-chenwuz-msft · Accepted solution]

Hi @julienvdc ,

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

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.

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.

[julienvdc]

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!