Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

conditionally hiding filter

Hello experts, I have a requirement where if I select one filter, the other filter should be greyed out.   Year Month     Year Week 202011     202045 202010     202040 202009 ...
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    I have a workaround.

    Though it is hard to make another filter grayed out,you can make it blank,when the other slicer is selected.

    Create 2 measures as below:

    Measure = IF(ISFILTERED('Table 2'[Year Month]),BLANK(),MAX('Table 3'[Year Week]))
    Measure 2 = IF(ISFILTERED('Table 3'[Year Week]),BLANK(),MAX('Table 2'[Year Month]))

    Then create 2 slicers and put the 2 measures in the filter field>"is not blank">apply.

    Finally you will see:

    For the related .pbix file,pls see attached.

     

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

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

Hi  Anonymous ,

 

I have a workaround.

Though it is hard to make another filter grayed out,you can make it blank,when the other slicer is selected.

Create 2 measures as below:

Measure = IF(ISFILTERED('Table 2'[Year Month]),BLANK(),MAX('Table 3'[Year Week]))
Measure 2 = IF(ISFILTERED('Table 3'[Year Week]),BLANK(),MAX('Table 2'[Year Month]))

Then create 2 slicers and put the 2 measures in the filter field>"is not blank">apply.

Finally you will see:

For the related .pbix file,pls see attached.

 

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!