how to filter efficiently with an analysis axis with more than 100,000 values on 10 levels?

[Cobra77]

hi ,

how to filter efficiently with an analysis axis with more than 100,000 values on 10 levels?

Hierarchy slicer : no longer respond and send very slow requests

Smart Filter is too long too to respond.

With 10 slicers it's really not easy to navigate between them

An idea ? good

Thans for your help

Best Regards

[v-jiascu-msft]

Hi @Cobra77 ,

Since you have a big list of options, one visual couldn't be proper for the people. We can't even see all of them. I would suggest you create ten slicers as they are on 10 different levels. You can navigate them from left to right, from top level to the low level.

Best Regards,