Forum Discussion
Use Slicer to Return All Items
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.
8 Replies
JorgastResolver II
Have you tried using bookmarks?
I would create 5 Bookmarks. Each bookmarked page you can filter to your specifications.
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
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).
