Create new category type by adding two different category types

[Anonymous]

I have a category type which includes a whole lot of different types. For the dashboard, i need only two types, which i have chosen and restricted via a page filter. The category type has been added as a slicer. The two categories are “Cabin” and “Site”. I also want to have a category called “Combined” which is the addition of the two categories. I know that selecting both cabin and site will give the same answer but is it possible to have a new category type as well?

How can I create a new cateogory called "Combined" from the site and cabin?

[v-yuta-msft]

@Anonymous ,

Generally, you may create a calculate column using dax below to create the new category column:

Combined = [Cabin] & [Site]

Community Support Team _ Jimmy Tao

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

[Anonymous]

Hi Jimmy,

Thank you for your response. The thing is 'Cabin' and 'SIte' are values of the 'Category Type' column. I don't want to create a new calculated column as I want the three values, Canin, site and Combined to be used in one slicer. If iwas to create a calculated column as you had mentioend, then the combined value will site separately. Then bringing in Category Type with values cabinand site will be one slicer and Combined value will come from the calculated column and create another slicer.

At any given time, the end user should be able to choose only one value, cabin, site or combined. If there are two slicers, they work independently, unless there is a way to lock the slicer choice so that only one value can be chosen at a time from both slicers.

If there is a different apporach I could use, please let me know.

[v-yuta-msft · Accepted solution]

@Anonymous ,

In the Format pane, click edit interaction and select one slicer, then there would be an "disable" icon in other slicers, click the "disable" icon. After that, the two slicers will have no interaction, you can combine different filter values as your requirement.

 

Community Support Team _ Jimmy Tao

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