Between slicer for categorical values

[bonus60]

Hello together,

I need you help again.

I am trying to create a between-slicer with categorical values/strings (e.g.: "A", "B", "C", "D", "E", "F"). That is easy with a date column. But I dont have the option to make the slicer as a between slicer with a column which has categorical values.

Do you have an idea?

Best regards

[dongtimadiya]

Thanks for sharing the post it was very helpful for me 

[amitchandak]

@bonus60 , 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) )

[bonus60]

@amitchandak 

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? 

[Anonymous]

Hi @bonus60 ,

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

[bonus60]

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

[Anonymous · Accepted solution]

Hi @bonus60 ,

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.

Slicers in Power BI

• Numeric range slicers.
• Relative date slicers.

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

[bonus60]

Hello togehther,

does someone have a solution for my issue?

Best regards