String Filtering with Segmenter

[Syndicate_Admin]

Hello

I have a question related to a segmenter. I'd like to see if there's a chance that filtering with a segmenter will filter me out more than one category. Let me explain:

I have a segmenter from 1 to 10, and I want that when you select 5, I select the immediately following ones, that is, from 6 to 10. I don't know if it's possible. Thank you

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

You can create a separate slicer table to control the segmenters (don't create a relationship). Then turn on show "select all" as on option in the slicer.

And finally use the following formula to control the selection range of the slicer.

M_ = 
var sel_ = SELECTEDVALUE('Values'[Value])
return IF(MAX('Table'[Value]) >= sel_,1,0)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Hello

Thank you very much for your answer and solution. It works perfectly, and by selecting one it filters out the other. But I've noticed that the filter is visual, and if I have the second table related to another one, the values are not updated when I do the filter. But that's another story. Thank you very much for your help.