Creating a greater than, less than or equal to slicer in Power Bi

[KatPrf]

Hi all! 
I am a Power BI newbie and I have a table in Power BI (called RatingOrder) which has the following columns:  agency, rating and order for each rating. Here is some sample data in the table:

Agency | Rating | Order

Blue | A++ | 3

Blue | A- | 2

Blue | B | 1

Red | A | 4

Red | B+ | 3

Red | B- | 2

Red | C | 1

I want the users to be able to select an agency (from a slicer) then choose ‘greater than’ or ‘equal to’ or ‘less than’ (which are determined by the order field) using another slicer, and then select a rating and get the results based on their selections. For example if they select agency = blue and greater than B, the results they should get are A++ and A-. Or if the select agency = Red and less than B+ the output should be B- and C.

Could you please let me know how to achieve the above? I know how to create simple slicers like the agency slicer that I mentioned above but not sure how to create the greater than, less than and equal to. 

[Anonymous]

HI @KatPrf,

Current the default filter/slicer does not support to use range mode on the table fields with text values.

For this scenario, I'd like to suggest you create a new table with filter mode text and write measure formula to check current records based on current selection item value and return flags.

Then you can use this formula as filter on 'visual level filter' to filter records.

Regards,

Xiaoxin Sheng

[amitchandak]

@KatPrf , You can use numeric parameters and create different types of slicers

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

[KatPrf]

@amitchandak Thanks so much for taking the time to respond! Unfortunately after reviewing the link that you sent I'm still unsure of how to achieve what I am after