Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RE: Need slicer

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
Need Help
  • AlB's avatar
    AlB
    7 years ago

    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.

     

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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.