put the data to slicer

Anonymous · ‎01-14-2019

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

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!

v-danhe-msft · ‎01-15-2019

Hi @Anonymous,

Could you please post your desired result if possible?

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources