Custom Date-Range Filter Erasing Visualizations

[Casey_Douthitt]

I am looking for a way to get a custom date-range slicer filter similar to the following image: 

However, whenever I follow tutorials online, selecting a value from the filter results in the entire
graph dissapearing from the canvas. I have attached my report as well as my dataset. The relevant tables in the
relationships are 'Date Filter', 'DateTable', and the Sprint Table. The end goal is to be able to filter Sprint Start Date with the custom Date Filter.

Below is a picture of the relavant tables in my dataset.

Here is a link to the report: https://drive.google.com/file/d/11DG1ctb0ulzrewK7S00HDYe8HltACKVg/view?usp=sharing

Thanks In Advance,

Casey Douthitt

[v-zhangti · Accepted solution]

Hi, @Casey_Douthitt 

I wasn't able to open your PBIX file due to dataset permissions, I simply simulated some data to hopefully match your situation. You can try the following method.

Column:

Filter = SWITCH(TRUE(),
[Date]>=TODAY()-7,"Last 7 Days",
[Date]>=TODAY()-28,"Last 28 Days",
[Date]>=TODAY()-90,"Last 90 Days",
[Date]>=TODAY()-365,"Last 365 Days")

Select the slicer at this point and the data corresponding to the time range will appear.

Best Regards,

Community Support Team _Charlotte

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

[Casey_Douthitt]

Here are screenshots of the before and after of using the custom filter