Forum Discussion
Anonymous
7 years agoNot applicable
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
Microsoft Employee
Hi Anonymous,
Could you please post your desired result if possible?
Regards,
Daniel He