One slicer for filtering two columns with overlapping values

[JanD]

Hello everyone, 

I am seeking for help /advise regarding creation of a filter that would combine two columns into one slicer.

The two columns looks like following:

Column1	Column2
A
B
C	D
D	D

I would like to create a slicer that would allow me to filter:

• category C without records of category D
• category D including some records from category C

I am not sure if this is even possible but I would appreciate any help.

Many thanks

Jan

[v-angzheng-msft · Accepted solution]

Hi, @JanD 

I doubt if it can be done with the default slicer.
As far as I know, you can use slicer and measure to achieve it.

For example, IF "isfilterd" then 1 else 0.
Let the measure get result 1, and then filter the items with measure 1 in the filter pane.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JanD]

Thank you @Greg_Deckler , 

But I wouldn't say creating a Group will help me or at least I am not sure how.

I have record categorized by Column1, however there is another category that combine two categories from Column1, however not fully. From Category C are taken only few records based on specific condition.

It's not like I simply combine two categories into a new one.

[Greg_Deckler]

@JanD Seems like you should use Groups to create a group column?