Forum Discussion
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" 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
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.
6 Replies
Anonymous
It's not working, Do we need to give relationship. If yes where to give. i mean to which column?
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)
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.
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
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.
