Including rows excluded in a other filter in a report

[Jesus]

Hi all,

I'm struggling my head and i don't know how resolve this situation:

I have one table with all data rows. One column of the report show -1 or positive value. The meaning is:

-1 = user never contacted

Positive value (i.e 24): Contacted 24 days ago.

I need to filter in the report:

Never contacted (value -1) AND contacted between 14 and 9999.

How can i perform this filter in the presentation layer?

[Omega]

In filter pane, you can manually deselect all the values between 0 & 14. Or, you can create a calculated column as and use if statement to flag all the values in the range you want. Then drag it to the filter pane. 

[Jesus]

Hi Omega, thanks for your answer but it doesn't solve my problem.

Having this data

1

2

3

4

5

6

7

8

9

10

...

..

500

(this values are dinamic from the table)

I want to obtain for example from 5 to 10 except 8...so i want to obtain 5,6,7,9 and 10.

It's for customer action, so is not possible use filter panel

[Omega]

Create a slicer and drag your column to it. Change the slicer to between. 

[Jesus]

Thanks omega for your quick answer.

Is not a valid solution because it doesn't allow take this result:

1,2,3,4,5,9,10

(avoiding 6,7,8). Is not valid neither a dropdown list

[v-chuncz-msft · Accepted solution]

@Jesus,

You may refer to the following posts.

• https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846
• https://community.powerbi.com/t5/Desktop/How-to-exclude-table-rows-from-a-Slicer/m-p/311185#M137871