View Date in 1st filter when "Custom Date" is selected in 2nd filter

[Saadaq]

Hi Members,

I am relatively new to BI and might be asking very basic questions. Below is the scenario of my problem;

I have created a Time Intelligence table using DAX and below are the options under the column name "Selection";

• Today
• Past 7 Days
• Past 1 Month
• Past 3 Months
• Custom Date

I have put the above "Selection" in a filter. I also have another filter by the name "Select Date" having all the "order date" in it.

Select Date filter is a date filter (between is used to create this filter) having all the order dates from start to end.

Below is the snapshot of the filters.

Fixed Dates:

Option 1-4 ("Today" till "Past 3 Months")

Option 5 "Custom Date" is the only date where user can select date range

Requirement 1: I want that when users choose "Custom Date" then the date filter appears only. And in the case of other selections, the date filter disappears.

Requirement 2: If Requirement 1 is not possible then values in the select date may disappear (blank) and users can not open the calendar.

Thanks