If I select 2nd slicer then slicer should select 1st slicer automatically

[Anonymous]

Hi Team,
I have below slicer , here is my ask
if i select 4 weeks ,then slicer should show only 4weeks. 
if i select 8 weeks in slicer then slicer shoud select 4weeks also automatically 
if i select 12weeks then it should select 4 weeks and 8 weeks automatically 
if i select 16weeks then it should select 4 weeks and 8 weeks and 12weeks automatically
if i select >16 weeks all the slicers i.e 4weeks , 8 weeks , 12weeks , 16weeks and >16weeks ..
please help me on this 

[Anonymous · Accepted solution]

Hi, @Anonymous 

I create a table:

Then create a calculated column and use the following dax:

Week Group = 
SWITCH(
    TRUE(),
    'Table'[Weeks] <= 4, "4 weeks",
    'Table'[Weeks] <= 8, "8 weeks",
    'Table'[Weeks] <= 12, "12 weeks",
    'Table'[Weeks] <= 16, "16 weeks",
    'Table'[Weeks] > 16, ">16 weeks"
)

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[Uzi2019]

Hi @Anonymous 

Try these video for custom calendar.

https://www.youtube.com/watch?v=JLupF1j49wo&t=966s

https://www.youtube.com/watch?v=8pDjbzNz1g8

https://www.youtube.com/watch?v=Xi86HHEaY_M

https://www.youtube.com/watch?v=hDopw1mPlrU

https://www.youtube.com/watch?v=Su1mERlwNdM

I hope above videos would help to create custom date slicer.

[Anonymous]

Not working @amitchandak 

[amitchandak]

@Anonymous , You have to create a measure and then use that as a visual level filter. But it will not default the value

Switch( True(),

"4 Week", countrows(filter(Table, Table[Date]>= today() -28 && Table[Date] <= today() ) )

// Add other

)

 Use that as visual level filter