Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

put the data to slicer

Hi Community,

 

I have just one ordinary column with date. 

start_at
2019-01-02T15:13:37.7280000
2019-01-02T14:38:52.4280000
2019-01-02T14:08:47.1900000
2019-01-02T14:08:47.1900000

 

What I need is to have ONE slicer with two checkboxes:

  • 'European business hours' (from 9am to 7pm)
  • and 'American business hours' (to make it simple I just say that it`s from 1pm to 11pm so we can use just the European time from the given table)

I can simply create a conditional column but the problem is they`re crossing each other. How can I deal with it? Any ideas?

 

Thanks in advance! 

 

1 Reply

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Anonymous,

    Could you please post your desired result if possible?

     

    Regards,

    Daniel He