Forum Discussion
Between slicer for categorical values
Hi Anonymous ,
Since the data type of the column Category is Text type, it will not display Between option on the slicer...Only the data type of the column is Date or Number, the Between option can enable in the slicer... You can find the details in the following official documentation.
Numeric range slicer
Date slicer
You can create a calculated column as below to rank the column Category and apply this new column on the slicer. Please find the details in the below screenshot or the attachment...
Rank = RANKX('Table','Table'[Category],,ASC,Dense)Best Regards
Super UserAnonymous , Create two independent tables on that and use two slicer for bewteen
Category Range Using 2 slicer =
var _max = minx(allselected(Cat1), Cat1[Date])
var _min = maxx(allselected(Cat2), Cat2[Date])
return
calculate(countrows(Table), Filter(Table,Table[Cat] <=_max && Table[Cat] >=_min) )
Thanks for your reply. Could you please describe your solution in detail? I did not get it to be honest.
I have to following table:
Table1
| Category | Value |
| A | 123 |
| B | 325 |
| C | 123 |
| D | 502 |
| E | 20 |
| F | 14 |
Now I should create two tables from Table1?
Hello togehther,
does someone have a solution for my issue?
Best regards
Hi Anonymous ,
Base on your provided data, how do you want to display the between slicer? Could you please provide some examples to describe your expected result? Thank you.
Best Regards
Hello Anonymous
thank you for your reply.
I just want to create a between slicer for the column Category in Table1, so I can slide between A, B, C, D E, F etc.
Something like that:
But I only have the option List and Dropdown within the slicer menu.
Do you have an idea?
Best regards
Hi Anonymous ,
Since the data type of the column Category is Text type, it will not display Between option on the slicer...Only the data type of the column is Date or Number, the Between option can enable in the slicer... You can find the details in the following official documentation.
Numeric range slicer
Date slicer
You can create a calculated column as below to rank the column Category and apply this new column on the slicer. Please find the details in the below screenshot or the attachment...
Rank = RANKX('Table','Table'[Category],,ASC,Dense)Best Regards