Forum Discussion
Combined selection
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,
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.
4 Replies
abukapsoun , Not ver clear. Create a slicer and give visual level filter for the value
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
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/
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.
