Forum Discussion

Mikerossanthony's avatar
Mikerossanthony
Frequent Visitor
7 years ago

Active Filters Pane Issues

Okay so lets say I have the following dataset:                Then I create a bookmarks for a user that filters to Company A, B, and C and Filters to only show Action Required. In this ex...
Need Help
d_gosbell's avatar
d_gosbell
Super User
6 years ago
Mikerossanthony wrote:

 

I tried using parent tables instead for the report filters, and had my active filters measure point to those tables:

 

This is the correct way of doing things. When you have a "parent" table (also called a dimension table) you should always do your filtering using that table where ever possible.

 

 

This makes the active filters pane behave as I'd like however since Report filter pane is looking at the parent table, every value is 1 which I don't think I can live with:

 

These values are just meant to give some indication of the row counts in the table you are filtering. They are not meant to provide any analytical value beyond that. 

 

Another option instead of using the filters pane would be to setup some slicers and then set them up to synch across the other pages on the report (you can set synch'ed slicers to be visible or hidden on your other pages)