Category selection for multiple values

[harib]

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" values in the table and same way for "MS-P "also. Here I also required when i select "MS-ALL" it should show all the records of "MS-I" and "MS-P". If we dont select any value from group it will show all the records, but i don't want that, when i select MS-ALL it should show all records.

Can anyone help in this.

Thanks in Advance

[v-yuta-msft · Accepted solution]

@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.

[v-yuta-msft]

@harib ,

You don't need to add a MS-ALL value in the GROUP column, in the formatting pane of slicer visual, there's a "select all" option, you can enable that option.

 

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]

HI @v-yuta-msft 

I have added MS-All in the group why because all the Prd_Name diferentiated with the Group (MS-I, MS-P) and MS-I and MS-P under the MS-ALL group. 

Here my scenario is we have a summary report. From the Summary to we are drilling to detailed report. 

In Summary we have "MS-ALL", "MS-I", "MS-P" values in group. When we select "MS-ALL" from the slicer and drilling to detailed report it should fetch all the records, like when we select "MS-I" it should fetch only "MS-I" records , Same way for "MS-P" also.

Unfortunatly my detailed report having only MS-I and MS-P values, there is not MS-ALL value.

Example : MS-All having 100 records in that MS-I having 40 and MS-P having 60 records

If i select MS-ALL it should fetch  complete 100 records.

If i select MS-I it should fetch  40 records.

If i select MS-ALL it should fetch   60 records.

Hope u got the clear requirment, Can anyone help in that

Thanks in advacne

[Anonymous]

Create a measure : 

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

then go to filters (on your table) :

Can you test this ?

[harib]

@Anonymous 

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

[Anonymous]

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)