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 th...
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.

     

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.