Forum Discussion

harib's avatar
harib
Post Patron
6 years ago
Solved

Category selection for multiple values

Hello All,   I have a senario . I have a category defined as Group with MS-I, MS-P values like below images. When i use Group column as a slicer if we select "MS-I " from Group it will show "MS-I" ...
Need Help
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    harib,

     

    You can modify your table as below and create two slicers based on Group and Sub-Group:

      

     

    Community Support Team _ Jimmy Tao

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

harib's avatar
harib
Post Patron
6 years ago

Anonymous 

 

It's not working, Do we need to give relationship. If yes where to give. i mean to which column?

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

In my case, I had 2 tables which were related via Id : 
- In you case you can create a table containing only the 3 groups then create a relationship between on the 2 tables based on the group.

If you select something in the first table, it will filter the 2nd.
So the first table is acting as a slicer

This is when nothing is selcted (2nd table empty) 

 

And this is when you select something in the first table :

 

 

I hope this can help you (in your case the first table would be the groups)