conditionally hiding filter

[Anonymous]

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			202040
202009			202039

Year Week 202040 falls both in October and September
Year Week being cascade to Year Month, will not give correct data for Year Week 202040 (as it will split in both Sep and Oct)
Is there any option in the filter where if Year Month is selected, Year Week will be greyed out and if Year Week is selected Year Month would be greyed out

Thank you in advance.

Best regards,

Manish Kumar

[v-kelly-msft · Accepted solution]

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!

[amitchandak]

@Anonymous , You can do it using bookmark and button. Not using slicer

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive