Forum Discussion
Solved
Slicer with multiple levels
Hello, I have different tables with ticket information. I want to filter by Queue, Customer, Agent and creation data, but I dont wanna have 4 different slicers ... is it possible to have a slicer...
Hey,
I would give these Custom Visuals from the Office store
Hope this gives you an idea
Visual Slicer doesnt work for me because it doesnt allow more than 2 different categories.
HierarchySlicer works fine! you can select more than 2 levels, and also Hierarchy from different tables. Thanks!
The Hierarchy Slicer seems to work well; however, when the matrix of categories contains empty cells, the slicer displays a lot of '(Blank)' levels. It would be nice if there was a way to specify to not display the '(Blank)' levels. If someone has a workaround for this, it would be much appreciated.
- add the field to the Report level filter ( open "Visualizations Pane")
- select "Advanced Filtering" in the "filter type" dropdown
- select "is not blank" in the "Show items when the value:" dropdown
Hope this helps!