Filter by both the top 10 and bottom 10

user04504

I built a standard bar chart to compare the variances between CY and PY. I would like to be able to drill down and see the top 10 and bottom 10 variances to PY at the same time. Does anyone have a solution to filter a drill through by both the top 10 and bottom 10 variances in a card? I can get either the top 10 or the bottom 10 using Chart Properties > General > Maximum Bars field. This needs to be dynamic and update based on new data, so a fixed beast mode won't work. Thanks in advance. 

 

@DaniBoy @jlafee

jlafee

We're using the card sort options right now and limiting to 10 rows, but is there a way to disable the A-Z and Z-A sort?  Flipping between Ascending and Descending values would do the trick, but right now it's just extra steps to click through alphabetical sorts to get back to Descending.