How can I slice with a field that can represent two values?
So I have a table called 'managers', and a field named 'worklocation'. Worklocation has a value of 'Location1', 'Location2', Location3', 'Location4', 'North', and 'South'. For the managers that has worklocation 'North', they cover 'Location1' and 'Location2'. The managers that has worklocation 'South', they cover 'Location3', and 'Location4'. I want to use a slicer using 'Location1' - 'Location4' only, and if 'Location1' is selected, it shows all the managers in Location1 and all the Manager's in 'North'. If Location2 is selected it shows all managers in Location2 and managers in North. If Location3 is selected it shows all the managers in Location3 and all the managers in South. If Location4 is selected it shows all the managers in Location4 and all the managers in South. Hope someone can help. Thanks.
According to your requirements, it can be achieved by creating a measure or calculated column. But need to provide test data (delete sensitive information) and expected results. I will answer for you as soon as possible.
Let me know immediately, looking forward to your reply.