Forum Discussion
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
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,
KellyDid I answer your question? Mark my post as a solution!
2 Replies
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
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,
KellyDid I answer your question? Mark my post as a solution!
