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.

jlf81's avatar
jlf81
Frequent Visitor
5 years ago

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