Forum Discussion
Deactivate slicer items
Is it possible to make some items unclickable?
I dont want that the Divisions can be clicked.. only the items of the division
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.
5 Replies
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.
