Deactivate slicer items

Hi tuncay 

If you don’t want Divisions can be clicked , you can remove Divisions from slicer .When you put fields in slicer , all the fields can be clicked .

Or you can combine Divisions and ID as a new column and then put the new column in slicer ,like this :

Division-ID = 'Table'[Division] & "-" & 'Table'[ID]

And the result is as shown :

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

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