Combined selection

[abukapsoun]

Hi Experts,

I have the following column

Col1

a

b

c

d

I want to create a dropdown list with X and Y. Where X will filters based on Col1 a & b, and Y filters based on c & d. 

Thanks,

[v-alq-msft · Accepted solution]

Hi, @abukapsoun 

Based on your description, I created data to reproduce your scenario.

Table:

You may right-click the 'Name' field and click 'new group'.

You need to Ctrl+click 'name1','name2','name3' and click 'Group' to group them as 'group1', and then do the same as above to create 'group2'.

Finally you may drag the new group into a slicer. Here is the result.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@abukapsoun , Not ver clear. Create a slicer and give visual level filter for the value

[abukapsoun]

Hi,

What I want to say is the following.. suppose I have a column with student names

name1

name2

name3

name4

name5

I want to classify them all into 2 groups, group 1 and group 2. My dropdown slicer would show only group 1 and group 2.

if i select group 1, it will show for example name1, 2,3 and if i select group 2 it will show name 4 and 5.

thanks

[amitchandak]

@abukapsoun 

Create a new column and put them into groups. And then use hierarchy slicer for Feb 2020 release; that would be better

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/