cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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  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

 

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi  @manish155 ,

 

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.

v-kelly-msft_0-1607655719879.png

Finally you will see:

v-kelly-msft_1-1607655736587.pngv-kelly-msft_2-1607655744868.pngv-kelly-msft_3-1607655754468.png

For the related .pbix file,pls see attached.

 

 

 

Best Regards,
Kelly

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

 

View solution in original post

2 REPLIES 2
Community Support
Community Support

Hi  @manish155 ,

 

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.

v-kelly-msft_0-1607655719879.png

Finally you will see:

v-kelly-msft_1-1607655736587.pngv-kelly-msft_2-1607655744868.pngv-kelly-msft_3-1607655754468.png

For the related .pbix file,pls see attached.

 

 

 

Best Regards,
Kelly

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

 

View solution in original post

Super User IV
Super User IV

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

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors