Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Responsive Resident
Responsive Resident

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

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
Responsive Resident
Responsive Resident

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.