Filtering a Filter: How do I NOT retain selection from previous filter

[Anonymous]

I have a report with two filters. My first filter is for book categories. My second filter is for specific Book Titles, and only one book can be selected at a time. When I select a particular book category, it filters the list of Book Titles. A specific Book Title can then be selected from the second filter, with gives details about the book.

Here's the challenge: Suppose I select the "GrumpStumpers" book under the Fantasy Category. When I switch to the Non-Fiction Category, the filtered list of books changes, but the "GrumpStumpers" book remains selected on the filtered list until I select a book from within the filtered list. Once I select another book, GrumpStumpers goes away as an option.

Is there any way to get around this so that the previous selection doesn't show up in the newly selected list of filtered items?

[parry2k · Accepted solution]

@Anonymous unfortunately there is no way around this, and this is the default behavior how it all works.

✨ Follow us on LinkedIn

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡