Help with table filtering

[Anonymous]

Hi  frnds,

I have a Power BI report page with a table. I need to give the users the option to click a button and the table should filter the records based on a condition. Note :I dont want to use bookmarks here as it will create multiple pages.  Please refer to the pic below. If I click the button in the left "Well Name is NULL" the table should  filter for the condition WELLNAME = NULL and display only those records and likewise for the other buttons . Please suggest a way or approach to achieve this. Thanks in advance.

[v-lili6-msft]

HI, @Anonymous 

For your requirement, you may try this way as below:

Step1:

Create three separate tables which only contain "Well Name is NULL", "PLATFORM is NULL", "START DATe is NULL"

Step2:

Drag them into slicer

Step3:

Then create measure as below:

FILTER for WELLNAME = IF(ISFILTERED(WELLNAME[Column]),CALCULATE(SELECTEDVALUE('Table'[WELLNAME]),FILTER('Table','Table'[WELLNAME]<>BLANK())))

And drag it into visual level filter of table visual and set is blank

Then do the same for "PLATFORM is NULL", "START DATe is NULL"

Result:

here is my sample pbix file, please try it

Regards,

Lin

[d_gosbell]

---

@Anonymous wrote:

Note :I dont want to use bookmarks here as it will create multiple pages. 

Bookmarks don't create pages. You can use bookmarks to hold a set of filters for the current page or a selected visual. Buttons with bookmarks should be able to do exactly what you are after, just applying a filter to the table visual (you'd probably want to add another button to "clear all filters" )