Dropdown Slicer visual bug

[bhavsarravi]

Hello,

I am using the slicer as a dropdown type. Where I have a format provided for Selection controls as "Single Select".

Now the problem here is, for example say I have two valuses in dropdown as Month and Week. As I have a Single select option ON, I am able to select eirther Month or Week. But at the same time I am also able to de-select both Month and Week which turns on into the Select All option. Is it this bug or default behaviour?

It should not allow to de-select both the values at the same time.

                                   

Kindly assist with this issue!

[v-qiuyu-msft]

Hi @bhavsarravi,

What do you mean "But at the same time I am also able to de-select both Month and Week"? Would you please clarify it? 

Not sure I understand your question very clearly. If we don't select any value in the slicer visual, it means slicer use all slicer values to filter data. You can add another table visual in the report to display the 'View by' column. 

Best Regards,
Qiuyun Yu 

[bhavsarravi]

Hi,

I have a Dropdown Slicer having two value in it, as Month and Week.

As I have a Single select option ON, that means I can select any one value from my dropdown value, ie; either Month or Week. (This is working good.)

But the problem here is slicer does allow user to deselect both the values (Month and Week) and the result is, it shows the data with respect to both the values. (Considering Select All)

Our requirement is to have atleast one value to be selected mandatory (either Month or Week). It should not allow user to deselect both the values. That is what we understand when we ON the Single select property. 

So is there any way to have atleast one value to be selected mandatory (either Month or Week) ?

[prateekraina]

@bhavsarravi

Power BI out of the box slicer works like that only. It allows users to deselelect all the values even though you have turned "Single Select" to ON.

Best workaround is to use Chiclet Slicer custom visual. There is a setting called "Forced Selection" in that. Turn that ON and you are good to go.

FYI, I also raised this issue with Power BI team long back but they replied saying its by design.

Prateek Raina

[v-qiuyu-msft]

Hi @bhavsarravi,

As @prateekraina replied, what you got is expected. You can try the workaround @prateekraina suggested. 

Best Regards,
Qiuyun Yu 

[bhavsarravi]

Hi @prateekraina/Qiuyun Yu,

Even for the Chicklet slicer the behavior is same. 

Now we are using chicklet slicer as suggested but it has the similar issue like, it is allowing to select mutiple values by Cntrl + Select (click).

Is not this bug in both the slicers?