Slicer to show values less or equal

[jakseadog]

Hello,

Here's my scenario:

In the Table I have column "A" with following values: 1,2,3,4.

I added slicer from this column, so I'm able to select between 1,2,3,4.

I want this slicer to filter table with column A, but in a little different way than normal - I want it to show rows with value A less or equal to value from slicer. Example:

1) On slicer I select 3 -> In the table I get rows with values A = 1,2 and 3

2) On slicer I select 2 -> In table I get 1 and 2

Could you guide me how can I achieve it?

[v-eqin-msft · Accepted solution]

Hi @jakseadog ,

Method1 : As @Anonymous  said, just choose "Less than or equal to"  as the type for the slicer:

Method2:

• Create a new table for slicer 

• Apply the following measure to filter pane like this:

Measure = IF(MAX('Table'[A])<=MAX('ForSlicer'[A]),1,0)

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

On your slicer there should be a little downward V icon in the top right corner when you hover over it. You can use it to select "less than or equal to", which I believe is what you're looking for.

Regards, 

Jasper