Use Slicer to Return All Items

[Chris_Evans]

Hello. I'm new to using Power BI. I am trying to use a slicer to filter data on a report and having a difficult time figuring out if I can get it to do what I want. The slicer is using a seperate table to get the filter items list so that I can control the order and include an All selection. The column that the slicer is using to filter is connected to another table that contains all but one of the items in the selection table. The one item that is missing is All Wintel Servers. The rest work prefectly fine to filter and adjust the report accordingly. What I would like is to have the All selection, return a combination of all the other 4 items. How can I best get this result. I have tried using the multi-selection option along with the select all button which when used in a very specific way, gets me the data I want but not the method. I need it to be single select. See the screenshots below. The slicer is connected to the table on the left to the scan selection field. That field is connected to the table on the right to Patch Group.

[Jorgast]

Have you tried using bookmarks?

I would create 5 Bookmarks. Each bookmarked page you can filter to your specifications.

[Chris_Evans]

Do bookmarks work with a published report or is that just for using Power BI Desktop? Also, I can't even figure out how to get this one option to filter all. Is there a way to change the slicer filter per object?

[Jorgast]

@Chris_Evans 

Yes you can have bookmarks in Power Bi Service for published reports. I normally set everthing up in the desktop environment first then publish to Power BI Service. 

If all the data was in the same table then a slicer would work. Since we have the All Winter in a different table then it adds some complexity. Are the columns in the All Winter table the same as the other table? IF so you could do a Merge/Append, That would combime all the data into 1 table and make filtering easier (just a thought).

[Chris_Evans]

The data is all in the same table. What i want is to capture with the All selection a combination of the other 4 filters. Each item in the table is categorized as one of those 4 items.

[Jorgast]

I am thinking in terms of category and subcategory

I would create a column

All_items = "All Items"

Have that as your page filter and then use your subcategory of the other 4 as your slicer. That was if the user doesnt select anything then it will default to All items

[Chris_Evans]

Seems like that will only work with the slicer set to multi-select. With single-select, it always has something selected. It works better for my needs to use single-select.

[TeigeGao]

Hi @Chris_Evans ,

According to your description, my understanding is that you want to create a slicer with all items and a "ALL" item. In this scenario, we can create a table with the data "item1", "item2", ..... "ALL" without relationship with any table, then create a measure to control the display of data, we can use the SELECTEDVALUE() function to get the data we select and use if .. else .. to judge the operation.

Best Regards,

Teige

[Chris_Evans]

@TeigeGao 

Could you give an example of how i would use that? I'm already using the selectedvalue() function for dynamic titles. How would I combine that with an If/Else statement and where would the measure be attached to? Is it a page level filter or does it have to be on each visualization? Thanks.