Incomplete filter options

[Anonymous]

Hi all,

In my report I have a page level filter that shows 4 of the 8 options when a date filter is set on 2020. When the date filter is removed, all 8 options show. However, when the date filter is set on 2020 and I manually fill one of the missing values into the advanced filtering box to show items when the value is >missing value<, the page correctly filters with what I would expect for the missing value. How is this possible? Screenshots below for clarity. 

Filter pane with missing values and date filter active

Complete list, date filter inactive

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Stephen Tao

[Anonymous]

Hi @Anonymous ,

It may be because the Naam column corresponding to your date column does not contain all the values. As shown in the following two figures, the Value column contains only four values(E,F,G,H) in 2021, so the four values(A,B,C,D) will not be displayed.

Or the date column and the Naam column are from different tables. In fact, it is similar to the above, the values not contained in the date column will also be filtered out.

Best Regards,

Stephen Tao

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

[Anonymous · Accepted solution]

Hi Stephen,

Thanks for your suggestion. However, this is not the case in my dataset.

I now solved it by removing my date filter, selecting the required filters, and then adding the date filter back in. This actually works and my data is now correctly filtered. 

When I remove the filters though, they disappear again from the filter pane and I need to repeat above method to add them back in.

I don't know how I can show my file without exposing my client's private data.

Kind regards,

Vincent

[Anonymous]

Hi @Anonymous ,

Now that you have solved the problem, you can accept your own reply as the  solution. 

More people will benefit from it.

Best Regards,

Stephen Tao

[amitchandak]

@Anonymous , if the date is part of the same table or with bi-direction with a table having this, this will filter out.

Also, there is no option to stop interaction between page level filters.

You can create a separate table for Naam and join it back with your fact table and use that in the page level filter. That should work.