Forum Discussion
Between slicer with categories
Hi Anonymous
You didn't miss anything.
Slicer between can work only with ranges of numeric / date data types.Groups that you created are texts, so you can use only lists/buttons/dropdown types slicers.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
I think that the answer is no, unfortunately.But maybe a card with catching selections near the slicer can help.
Something like that :I attached a pbix , if it helps you can follow my steps.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Whilst I haven't found a proper solution, I have created a workaround. I connected a table containing the order in which I need the categories (1-5) with the corresponding categories. I created the between slicer with these numbers but set the value color to the background so it doesn't show. Then I overlayed it with 2 card visuals. One with the lowest selected category, one with the maximum. The DAX formula is as follows:
MinimumCategorieContracten =IF(MIN(VolgordeContracten[Volgorde])=1,"Verleden",IF(MIN(VolgordeContracten[Volgorde])=2,"<11",IF(MIN(VolgordeContracten[Volgorde])=3,"<21",IF(MIN(VolgordeContracten[Volgorde])=4,"<31",">30"))))Same goes for Maximum, but obviously with MAX().I know this isn't optimal but it does work.If anyone has any improvements, please do tell!
Whilst I haven't found a proper solution, I have created a workaround. I connected a table containing the order in which I need the categories (1-5) with the corresponding categories. I created the between slicer with these numbers but set the value color to the background so it doesn't show. Then I overlayed it with 2 card visuals. One with the lowest selected category, one with the maximum. The DAX formula is as follows: