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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create a measure : 

Measure = IF ( ISFILTERED('list'[Group]), BLANK(), 50 )

then go to filters (on your table) :

 


Can you test this ?

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)