Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!
Alright sounds good. Thanks!
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |