Dependent dropdown with single select in Power BI

[Anonymous]

Hi,

I have 2 slicers on my report with single select enabled:

Slicer 1 - having option A and option B
Slicer 2 - Having list of options when A is selected (say u, v and w) and another list of options when B is selected (x,y,z)

When I select option A in Slicer 1 and one of the sub-options from Slicer 2, and then change value in Slicer 1, it retains the sub-option that was previously selected in Slicer 2 even when it is not a part of the list of sub-options for Slicer A. 

Is there a way to clear out the Slicer 2 entirely or by default have one of the sub-options selected when options are changed in Slicer 1? Can we do it using dax?

P.S. It can be done using custom hierarchical slicer but I can't use that since I'm already using one custom visual and don't want to increase the load on the file.

[v-shex-msft]

Hi @Anonymous,

Current power bi does not support directly reset/modify the current selection based on filter interaction or DAX expressions. I'd like to suggest you submit an idea for this requirement.

Microsoft Power BI ideas

Regards,

Xiaoxin Sheng

[PVO3]

Hi Kavish

It's hard to understand what your asking. But I think you are looking for something like this:

RemoveFilters =

SWITCH(TRUE(),

   ISFILTERED(TableA), CALCULATE([Measure], REMOVEFILTERS(TableB)),

   ISFILTERED(TableB), CALCULATE([Measure], REMOVEFILTERS(TableA))

)

It cancels filtering from one of the slicers. But I'm not sure what you want to do when both are filtered.

Or maybe you are trying to say that the interaction between the 2 slicers isn't working like expected. Depending on your model this can be fixed by FORMAT --> Edit interactions. Or by creating a measure and use this a a visual filter.

But to be honest it sounds more like you should rearrange your model.  

[Anonymous]

Hi,

Thanks so much for your response.

I'm trying to achieve the functionality of the custom chiclet slicer (forced selection feature) found of appsource, using the standard slicer visual in Power BI. 

I'm facing the issue that's mentioned in this post:
https://blog.crossjoin.co.uk/2019/07/10/power-bi-slicers-show-values-that-do-not-exist/

[PVO3]

So you don't want blanks to show up in your slicers? This basicly means the many side of your relation can't match on all keys in the one side. Assuming you have a many to one relation. Seems like a whole other question.

I'm sorry but I think I don't understand. Perhapse someone else can help you.