Bidirectional filter not properly working between calendar table and fact table

[Anonymous]

Hi everybody,

I'd need some help with regard to my simple data model, as shown:

I have a Calendar Table with a Unique column, Anno, in which i have listed:

• 2020
• 2021
• 2022
• 2023
• 2024

And a Fact table with this data within:

I need to use Anno column from Calendar Table as a filter in my home page, and i would like to get rid of 2024 year, that contains no values in it.

I have tried with bidirectional filter between the two tables, but still i got 2024 in my filter.

Am I doing something wrong?

Thanks,

D

[Anonymous]

Hi @Anonymous ,

Based on your description, I'm wondering that you chose "show items with no data", you may check the result by cancel it:

Best regards,
Community Support Team_ Scott

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

[some_bih]

Hi @Anonymous try to remove it from Celendar table.