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
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.