Hi dflak,

I'm trying to create a tool to compare the overall value of an specific model vs. the similar model of the competition. Using car brands as an example Mazda 3 2018 vs Civic 2018, they have similar characteristics but some features differentiate both models, this difference in configuration gives a value/grade to the product.

Slicers are a good option to achieve this, however, the down side is that I would need to create two sets of each slicer making the dashboard look crumbled with many duplicated slicers and most importantly using this method would make the user need to drag down the list with more than 30 features to find what they're looking for vs. being able to do a 'search' just as pivot tables allows when the drop down for filters is clicked.

My thoughts in achieving this was about having two different pivot tables described in the opening post (Selecting a Filter in Filter 1, will only show specific filters in the rest of the filters related to Filter 1), that way the users could have a much cleaner tool vs. using slicers.

I don't know if there is a way to accomplish this but please let me know your comments.

Thank you for your time,
D