cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Continued Contributor
Continued Contributor

Can filters in the Filter Pane filter each other ?

Is it possible for filters in the Filter Pane to filter each other without using a bi-directional relationships?

Click here for PBIX 

 

The attached PBIX has 2 reports:-

Report with slicers - which uses slicers

Report with filters – which uses the filter pane

 

The Report with slicers uses a COUNTROWS dax measure to filter the slicers.

For example if the user selects Species = Dog then the Breeds slicer will only display breeds of dogs and not cats or birds.

 

Whereas on the Report with filters, if the users selects Species = Dog then the Breeds slicer shows breeds of dogs, cats and birds.

 

Is there a way of filtering the Filters Pane?

I do know it can be done by setting the relationship cross filter direction = Both , but I don’t want to use bi-directional filtering.

 

Is it possible for filters in the Filter Pane to filter each other without using bi-directional relationships? I expect not.

 

Thank you.

2 REPLIES 2
Super User IV
Super User IV

@speedramps , They are from the same table. Unless a hierarchy is created. They will filter each other. I checked your file, both in the filter pane and slicer bidirectional filtering is happening



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Sorry amitchandak, I attached the wrong PBIX example.  Please try this one ....

 

Click here for PBIX 

 

The attached PBIX has 2 reports:-

  • Report with slicers  - which uses slicers
  • Report with filters – which uses the filter pane

The Report with slicers  uses a COUNTROWS dax measure to filter the slicers.
For example if the user selects Species = Dog then the Breeds slicer will only display breeds of dogs.

Whereas on the Report with filters, if the users selects Species = Dog then the Breeds slicer shows  breeds of dogs, bids, fish and cats.

Is there a way of filtering the Filters Pane?

I know it can be done by setting the relationship cross filter direction = Both , but I don’t want to use bi-directional filtering.  

Is it possible for filters in the Filter Pane to filter each other without using bi-directional relationships?  I expect not.

Thank you. 

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors