RE: Need slicer

[Anonymous]

Hi Zubair_Muhammad , v-shex-msft I have two columns like below YearMonth 201901 201902 ..... startDate Mon2019-01-01 Tue2019-01-02 wed2019-01-03 ------ like till each month total days. so I want a slicer with 10Days,20Days,30Days so when ever user select yearMonth and 10 days means I want to see the chart for 10days only like that I want to achieve how can I do? best chanty

[AlB · Accepted solution]

Hi @Anonymous 

You can select the desired range of days easily in the visual level filters

Or you could create an additional calculated column that assigns a value depending on the day: 

- "1st 10 days" for days 1 to 10

- "2nd 10 days" for days 11 to 20

- "3rd 10 days" for days 21 to 30

As an example, for the first 20 days you'd select "1st 10 days" and "2nd 10 days" in the slicer.