Forum Discussion

hanrft's avatar
hanrft
Regular Visitor
1 year ago
Solved

Using overlapping date periods in a slicer

I am working with dates that belong to multiple 'star ratings' periods.  These are the current upcoming periods, they follow the same logic ongoing:  Mar25 QTR = 1 Jun 23 to 31 May 24 Jun25 QTR = ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the reply from govind_021 , please allow me to add some more information:
Hi  hanrft ,

 

You can try to create a slicer table with “Mar25 QTR” “Jun25 QTR”, create a measure with the Switch() function to customize the rule, place the Filter with 1 or 0.

Here are the steps you can follow：

1. Home – Enter data – Create a slicer table.

2. Create measure.

Flag =
var _select=SELECTEDVALUE('Slicer_Table'[Group_Slicer])
RETURN
SWITCH(
    TRUE(),
_select="Mar25 QTR" && MAX('Table'[Date])>=DATE(2023,6,1) && MAX('Table'[Date])<=DATE(2024,5,31),1,
_select="Jun25 QTR" && MAX('Table'[Date])>=DATE(2023,9,1) && MAX('Table'[Date])<=DATE(2024,8,31),1,
_select="Sep QTR" && MAX('Table'[Date])>=DATE(2023,12,1) && MAX('Table'[Date])<=DATE(2024,11,30),1,
_select="Dec QTR" && MAX('Table'[Date])>=DATE(2024,3,1) && MAX('Table'[Date])<=DATE(2025,2,29),1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

 

Best Regards,

Liu Yang

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