cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DukanBI
Regular Visitor

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 filter the value of my sales as

Button 1 - all categories except A1, 

Button 2 - all categories except A3, and

Button 3 - all categories

 

Alternatively, this can done by using slicer. However, in my case it is not user friendly as item categories number is high and requirment is for specific filters only. 

 

Please suggest me a simple method to achieve this.

 

Thank you

1 ACCEPTED SOLUTION
JoaoMarcelino
Super User
Super User

Dear @DukanBI ,

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

JoaoMarcelino_0-1669818705824.png


4. The result is this:

JoaoMarcelino_1-1669818768620.png

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!

View solution in original post

1 REPLY 1
JoaoMarcelino
Super User
Super User

Dear @DukanBI ,

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

JoaoMarcelino_0-1669818705824.png


4. The result is this:

JoaoMarcelino_1-1669818768620.png

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!

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.