Slicer with multiple levels

[serargi]

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 with different levels? I mean for example.

First of all select queue, then it shows customer, then agent and then creation date

thanks!

[v-yulgu-msft]

Hi @serargi,

As suggested by TomMartens and MFelix, a HierarchySlicer might the best choice. If this could meet your requirement, please kindly mark the corresponding reply as answer so that more users can benefit from here. If you still have any question, please feel free to ask.

Regards,
Yuliana Gu

[TomMartens · Accepted solution]

Hey,

I would give these Custom Visuals from the Office store

• Attribute Slicer
• HierarchySlicer

Hope this gives you an idea

[serargi]

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!

[powersmart]

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.

[Anonymous]

1. add the field to the Report level filter ( open "Visualizations Pane")
2. select "Advanced Filtering" in the "filter type" dropdown
3. select "is not blank" in the "Show items when the value:" dropdown 

Hope this helps!

[MFelix]

Hi @serargi,

Try the custom visual hierarchy slicer you can get it from:

https://store.office.com/pt-pt/app.aspx?assetid=WA104380820&sourcecorrid=d0247b8e-1e57-48ce-b90b-521...

Regards,
MFelix