How to force multi select on a slicer

[mazwro]

I have a slicer with values

A, B, C, D, E

Users can select one or multiple from the dropdown.

Is there a way to set up the slicers so that users can pick A,B,C as normal, but when they click on D, automatically E is selected as well?

So there is no way to choose D without E.

[mazwro]

this did the trick. So simple 🙂

[DataNinja777 · Accepted solution]

Hi @mazwro ,

This is a very primitive solution but what about creating a calculated column as follows and use that as a slicer? 

A	A
B	B
C	C
D	D & E
E	D & E

Best regards,