Combining filters in to single filter groups

[Justas4478]

Hello, I am trying to combine these filters Picture1 in to sort of groups since some of them belong in same categorys. Example Christmas Card and Christmas Party & Gifting would be together in one filter named Christmas or Christmas cards same would go for Easter ones and other ones. At the end I should have just Christmas,Easter, Fathers Day what would be combinations of two similar slicers. My question is how do I archieve that do I have to use custom colums for that? Since I am using live data set is it doable using measure or custom column is only way? Thank you.

[v-luwang-msft · Accepted solution]

Hi @Justas4478 ,

Just like the below,But you need to configure it from the source, because you are using live connection：

Create a new column to intercept the first space：

And final get :

Wish it is helpful for you!

Best Regards

Lucien

[amitchandak]

@Justas4478 , As far as I know, a custom column is the only way. As you are using the live connection, you have to do it at the source. Split the column by space and keep first occurrence

[Justas4478]

If I do that would the new after spliting column example Christmas filter. Would it get the data that was relating to Christmas Card and Christmas Party & Gifting?