The simplest approach would be to create a calculated field that gives you the stage number. If the data is as you've noted above, you could do this:
// Get the number from the stage dimension and make it an integer.
You could also do a case statement
// Convert the stage dimension to a number.
WHEN '1-Lead' THEN 1
WHEN '2-Contacted' THEN 2
WHEN '3-Interested' THEN 3
WHEN '4-Drafted agreement' THEN 4
WHEN '5-Signed agreement' THEN 5
WHEN '6-Customer' THEN 6
Those will then be measures, which will allow you to create a slider-type filter. See attached workbook for examples.
Stages.twbx 12.5 KB
Thanks Ken thats what I'm looking for but is it possible to include the stage names on the slider as the users aren't familiar enough with the numbers representing the stages.
I don't think so, unfortunately. One option might be to add a key that shows the numbers with the corresponding stage name, as a reference.