Deactivate slicer items

[tuncay]

Is it possible to make some items unclickable?

I dont want that the Divisions can be clicked.. only the items of the division

[v-yetao1-msft · Accepted solution]

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.

[jppv20]

Hi @tuncay ,

Maybe you can create a new column with "Division + Item":
Division I - 100010
Division I - 100202
Division I - 100204

Etc.

Jori

[mussaenda]

Hi @tuncay ,

Then maybe it is better not to put the divisions on the slicer?

[tuncay]

There is a hierarchy structure and when I exclude the divisions, I can't see the IDs anymore..

[mussaenda]

What is showing when Division is removed?