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 sli...
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.

     

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.