filter questions

[Anonymous]

Hello,

I have 2 questions linked to the attached image please.

I have 3 tables in my model, without relations defined in the model, but they all come from a common reference to my main "fact" table. Each enables me to fill a different visual in my report.

1/ I don't understand why, in the visual filter, I have 3 times the field "Date de mise en service" (circled in red) ? Why don't they also all have the same filtering options (the first two allow me to select "lower than" or "greater than" for instance in the advanced filter dropdown list, but the 3rd one has a different list of advanced filters) ?

2/ In my filter I want to say that the visual should display only the elements that are after a certain date, so I chose the visual date filter (so one of the three...) and select "advanced filter" / "is greater than" and enter a date but it says I can only enter numbers (highlighted in yellow). How should I format my date there to get only the values greater to a specific date ?

Thank you for your help

[daXtreme]

Without the file itself it's not possible to give definitive answers. Sorry.