cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Filter Button to Show Only Available Rows

I have a set of data and I want to have a button that shows only the rows that have clients and be able to switch back and forth. 

Below is picture of power bi table and my excel data and the filter pane. For example I want to only see the row of LA and Miami county because those are the counties with clients. 

 

Annotation 2020-06-02 113538.pngAnnotation 2020-06-02 114052.pngAnnotation 2020-06-02 114308.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Filter Button to Show Only Available Rows

Hi @adambarek ,

 

you can save the filter selection as a bookmark and link the bookmark with a button.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks#:~:text=With%20bookmarks%...

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether

View solution in original post

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Filter Button to Show Only Available Rows

Hi @adambarek ,

 

you can save the filter selection as a bookmark and link the bookmark with a button.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks#:~:text=With%20bookmarks%...

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors