I am puzzled on how to do something. The users want to create custom filter selections based on two columns. They do not want to independent slicers (which would be so easy). They have a few combinations of two columns they like to see together and would like users to be able to select from those. For example, given this data
ID Leave Mode Reason
1 Involuntary Death
2 Voluntary Other
3 Involuntary Other
4 Voluntary Retirement
5 Involuntary Retirement
6 Involuntary Death
7 Voluntary Retirement
8 Voluntary Other
They would like to have the user’s select from the following choices in a filter:
Voluntary (Excluding retirement)
Involuntary (Excluding retirement)
They would like them to be able to select one of the above choices and then the table would filter to show only those rows with the matching Leave Mode and/or Reason that is in the filter.
My question is, how to I filter a table when the slicer selection does not represent a row value. When I had two slicers, it was easy to have them select a mode and/or a reason and the data filtered naturally. I am puzzled as to how I can filter the table based on the selections that they want especially when the combine values from two different columns in the data.
Hope that is clear!
Thanks in advance,