Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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.
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.
@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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |