Change name of slicer variables

[pantherfanrh]

What's the easiest way to rename the variables in a slicer? For instance, I have several values in my slicer called EQUIPMENT_TYPE, with values 1,2,3,4,5 etc. where 1 stands for a stapler, 2 for scizzors, 3 for a pc, and so on. When I set up the slicer, the slicer shows the values as 1,2,3,4,5 etc, and I'd like it to show stapler, scizzors, pc, and so on. How would I do this? Thanks!

[vanessafvg · Accepted solution]

is that data anywhere in your model?  id probably add a custom calculated column in power query in the table where your id no is

if EQUIPMENT_TYPE= 1 then "value 1"

else if EQUIPMENT_TYPE= 2 then "value 2"

etc

[pantherfanrh]

Alright sounds good. Thanks!