Filters on all pages

[M_SBS_6]

Hi, 

I have applied several filters to my dashboard on all pages, but not sure it quite does what I need I to. 

I have a drop down filter and it displays values that it shouldn't. It's almost as if the filters applied on all pages uses an "or" opposed to an "and".

If all filters applied used an "and" then I would see the correct values within my filter drop down but I don't. Any idea how to get around this please?

[Mikelytics]

HI  @M_SBS_6 

maybe this could be the reason.

Do you use a model with multiple tables and relations? IIf yes please be aware that filters go only through the relations as allowed by the direction (see arrow in data model)

so in my example above

- Dim Date filters Base Sample

- Dim Type filters Base Sample

- Dim Type DOES NOT fitler Dime Date

- DimDate DOES NOT filter DIM Type

- Base Sample DOES NOT filter Dim_Type or Dim_Date

You can change the filter direction behaviour by double-clicking on the relation but please be aware that it could end in not following best practices

If this this does not help then we need more information (data model and screen shot)

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

[amitchandak]

@M_SBS_6 , not very clear. If the filter pane is used Or is within a field, across field it is and

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[M_SBS_6]

My filter on all pages are 

Year > 2015

Status = Live

Type = New

My filter which is "Company" shows me BRNT_Canada but not sure why as it doesn't match the filtered criteria above. 

Year > 2015

Status = Live

Type = Rec (this is a different value to the filters)

So to me, the criteria used on filter all pages is 

Year > 2015

OR

Status = Live

OR

Type = New

Where as I want to only show "Company" that meets all 3 criteria 

Year > 2015

AND

Status = Live

AND

Type = New