Custom filter

Hi All, I want to create a button that can act as a filter for my dataset. Example - I have 20 item categories - A1, A2, A3, ........., and A20. In this case, I want a button that can filte...

Need Help

JoaoMarcelino
3 years ago
Dear Anonymous ,

Welcome to this amazing community 🙂

1. I would do it, for example, with 3 bookmarks:

Bookmark 1 - Drag category to page filter pane -> select "basic filtering" -> add new bookmark -> select everything from categories but A1 -> update bookmark

Bookmark 2 - add new bookmark -> select everything from categories but A3 -> update bookmark
Bookmark 3 - add new bookmark -> select everything from categories ->update bookmark

2. Rename the bookmarks as intended (e.g. "All except A1", "All except A3" and "All Categories")

3. Go to Insert -> Buttons -> Navigator -> Bookmark navigator

4. The result is this:

It takes about 5minutes to do it 🙂
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

Hope I was of assistance!
Cheers
Joao Marcelino
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Forum Discussion

Custom filter

Related content

Customer Scorecard

Filter

Custom Visual

Filtering a Custom Column

Custom date filter