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 tab...
TeigeGao
Solution Sage
Solution SageHi 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
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.