Forum Discussion

Casey_Douthitt's avatar
Casey_Douthitt
Frequent Visitor
4 years ago
Solved

Custom Date-Range Filter Erasing Visualizations

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

Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

     

2 Replies

  • Casey_Douthitt's avatar
    Casey_Douthitt
    Frequent Visitor
    4 years ago

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

     

     

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    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.