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
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.