Forum Discussion

Chris_Evans's avatar
Chris_Evans
Frequent Visitor
7 years ago

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 tab...
Need Help
Jorgast's avatar
Jorgast
Icon for Resolver II rankResolver II
7 years ago

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's avatar
Chris_Evans
Frequent Visitor
7 years ago

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's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage
    7 years ago

    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's avatar
      Chris_Evans
      Frequent Visitor
      7 years ago

      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.