Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter table based on column value starting with

So I have a table, with many columns, and one column which is "serial_number". Below my table, I want to have a button that when clicked (like an on/off switch) would show ONLY the table rows for whi...
Need Help
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    Hi Anonymous 

    This can be achieve using bookmarks. 

    You can create one bookmark by adding advance filter as starts with on serial_number column 

    and add one more bookmark without filter for "off" condition

     

    Now you add two buttons one for on and one for off. Put action type as bookmark and select respective bookmark for your button action

     

    Thanks

Samarth_18's avatar
Samarth_18
Community Champion
5 years ago

Hi Anonymous 

This can be achieve using bookmarks. 

You can create one bookmark by adding advance filter as starts with on serial_number column 

and add one more bookmark without filter for "off" condition

 

Now you add two buttons one for on and one for off. Put action type as bookmark and select respective bookmark for your button action

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI being the least intuitive app I have ever used in my life (along with other Microsoft products), I am still stuck as I don't know how to "create one bookmark by adding advance filter as starts with on serial_number column" - No idea how I should do that.