Can we get interactive filter options that work like quick filters do?
For Dates I'd love to be able to just type in the date range as opposed to having to use the current option. Range selector is just not very functional.
For lists that could be in the hundreds, it would be nice to have search functionality
Also I'm having issue getting my slicers to order themselves correctly. I have a date range slicer beastmode:
(CASE
when CURRENT_DATE()-`date` < 8 then '0 - 7 days'
when CURRENT_DATE()-`date` < 31 then '8 - 30 days'
when CURRENT_DATE()-`date` < 61 then '31 - 60 days'
when CURRENT_DATE()-`date` < 91 then '61 - 90 days'
when CURRENT_DATE()-`date` < 181 then '91 - 180 days'
when CURRENT_DATE()-`date` < 366 then '181 - 365 days'
else '+366 days'
end)
And a dummy version to order them:
(CASE
when CURRENT_DATE()-`date` < 8 then '1'
when CURRENT_DATE()-`date` < 31 then '2'
when CURRENT_DATE()-`date` < 61 then '3'
when CURRENT_DATE()-`date` < 91 then '4'
when CURRENT_DATE()-`date` < 181 then '5'
when CURRENT_DATE()-`date` < 366 then '6'
else '7'
end)
But it isn't ordering based on the dummy version. It's ordering it as such (attached file)
If you know how to get it to order correctly please let me know.