Forum Discussion

Koritala's avatar
Koritala
Icon for Post Patron rankPost Patron
10 months ago
Solved

Custom Date Range Slicer

Hi, Could you help me with the scenario below?   I want to dynamically show the 2 differnt date slicers based on slicer value slection.   In slicer, I should have 2 values, one is MTD, second on...
Need Help
  • Koritala's avatar
    Koritala
    10 months ago

    Hi Ugendar,
    Thanks for your solution. it working as expected.

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
10 months ago

  

Create a disconnected table with values MTD and Custom.

Use a measure to set min/max dates based on the selected value, e.g.:

DateFilter =
IF(SELECTEDVALUE(Slicer[Type]) = "MTD",
Dates[Date] >= STARTOFMONTH(TODAY()) && Dates[Date] <= TODAY(),
TRUE()
)

Apply this as a visual-level filter on your date slicer.

 
 

Koritala

Koritala's avatar
Koritala
Icon for Post Patron rankPost Patron
9 months ago

Hi Kedhar,

can you please share the pbxi file. I couldn't get the result.

Thanks,

Sri