Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

dynamically disable slicers

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 (Mon...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, Anonymous 

    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)
    1. 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.

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, Anonymous 

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)
  1. 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's avatar
prabhatnath
Advocate III
2 years ago

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