Forum Discussion
dependent slicers
let say i have two slicers in report - one is for selcting "Year" and another is for selecting "City", requirement is user should not allow to select values in "City" slicer until and unless atleast one value is selected in "Year" slicer, can this be acheived in power bi? if not then is there any workaround possible?
You can use a measure that checks whether the first slicer columns is filtered and return a valeu if it does. Use it as visual filter for the second slicer.
Slicer Filter = IF ( ISFILTERED ( Reseller[Business Type] ), 1, 0 )
3 Replies
You can use a measure that checks whether the first slicer columns is filtered and return a valeu if it does. Use it as visual filter for the second slicer.
Slicer Filter = IF ( ISFILTERED ( Reseller[Business Type] ), 1, 0 )Hi powerbiexpert22,
Thank you danextian for your response to the query.
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi powerbiexpert22,
Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help.
Thank you.
