I’ve got a table which contains rows belonging to three overlapping categories.
I want to filter the table dynamically using a slicer.
To be exact: I have row numbers and want the end user to be able to toggle between showing rows 1-13, rows 1-26, and rows 1-65. I want to give each of these ranges friendly names and for the user to be able to toggle between the categories using a single select slicer. I’d like to avoid using a sliding bar because it is deeply unintuitive in the context.
Is there a way to do this in PowerBI? It seems like it should be easy but I’ve struggled to get any traction on the problem.