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!
So there is no way to link integers from 1-5 to the categories, and use them as a between slicer but make it display the group name rather than the integers?
Super UserHi 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
Thank you for your effort!