see the attache
you book is a twb without the data so I used superstore data - see attached
first I dropped an index on the viz
set it to discrete and calculated it like this
then ad a lookup function on the index
add to the filter shelf and calculate it the same as the index add a slider control
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
lookup index.twbx 2.4 MB