dynamically disable slicers

[RohiniP-26]

Hi All,

I have the above three slicers in my report. I need to know that can slicers be disabled dynamically ?

for ex: If i select any one value in Year slicer, then other two slicers (Month ans SalesNo) must in a disabled state.

How can i achieve this ?

Thanks...

[v-robertq-msft · Accepted solution]

Hi, @RohiniP-26 

According to your description, I think you can achieve this using a measure and a visual filter, you can try my steps:

This is my test data based on your sample picture:

1. Create a measure:

Flag =

IF(ISFILTERED('Date'[YEAR]),1,0)

2. Apply the filter to the two slicers like this:

And you can get what you want, like this:

When you selected one value in the Year filter, you can not select any value in the other two filters.

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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

[prabhatnath]

Hi @v-robertq-msft  your solution is working great and I have tested it today.

The similar measure I have created and used in my visual but that does not work instesd I can see a "i" icon above the slicer and that shows message that Cant not display this visual, but I can see the visual.

Example Your Sample (It hides the visual and no "i" icon)

Here is My Example with the "i" icon but the slicer is visible.

On click on the "i" icon this dialog shown.

What could be the issue here?

Thanks,

Prabhat

[jlf81]

I would think you could build something with tables created by DAX for the slicer to remove the other value, using something with SELECTEDVALUE and then use inactive relationships and use measure USERELATIONSHIP to define which table you filter from again using SELECTEDVALUE.

Might be quite complicated.

The other option is put them all in one slicer and then use a link table to filter it just to the bits you want eg 2021 would have all the periods in 2021 in the link table atributed to it and Jan would have all the Januarys attributed to it

[amitchandak]

@RohiniP-26 , I doubt you can do that.

The only way to control is bookmark and buttons https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive