Forum Discussion
Filters: How to prevent a filter selection from filtering other filters selections.
Hi,
I have a report that I need to set filters up for. However, I don't have all the data permutations that would allow for all the required options to be selected across the filter set. So don't want the other filters to filter out any field options so that I can select all the filters I need.
Is there a way to prevent this from happening or is there a way to set the filters that I need outside of the filters panel?
Any help suggestions would be great.
Thanks.
Greg_Deckler Thanks. I have resolved my issue. The elements I was wanting to filter on were part of the data set. I made these into separate list tables and filter off the lists.
5 Replies
You can check edit interactions SirTim
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
If you want to hide your visual filters
https://www.youtube.com/watch?v=xy9nmSQeUWg
Thanks
Thanks. Not what I was wanting to achieve but have learnt something new here.
- Greg_Deckler
Community Champion
SirTim Well, you can filter individual visuals in the Filter pane and you can also filter inside of measure formulas. Hard to be specific with the information provided. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Greg_Deckler Thanks. I have resolved my issue. The elements I was wanting to filter on were part of the data set. I made these into separate list tables and filter off the lists.
hi_worldHelper III
hello,
Could you please explain your solution a bit more? Thank you
