Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with table filtering

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.

 

Need Help

2 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    6 years ago
    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" )

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    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