Forum Discussion
d9801
1 year agoFrequent Visitor
Disabling Slicers when using another Slicer
Hi, I am trying to disable the Date Filter when Year/Quarter is selected in Date Selection. The formula that I am using to achieve this is: I then add Disable Date Slicers to the Filte...
- Anonymous1 year ago
Hi d9801 ,
The Date filter can only be used if the value of the filter is “Custom”.
Please try:
Disable Date Slicers = IF(SELECTEDVALUE('Date Calculation Selection'[Date Selection]) = "Year/Quarter",0,1)Or
Disable Date Slicers = IF(SELECTEDVALUE('Date Calculation Selection'[Date Selection]) = "Date Range",1,0)Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum