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 bo...
Need Help
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