Forum Discussion
Use Slicer to Return All Items
Resolver II
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).
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
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.
TeigeGaoSolution Sage
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