Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to create a custom SLICER?

Hello   I have two sets of criteria, e.g.: CriteriaSet1: Col1 = A || Col2 <> B && Col3 = C CriteriaSet2: Col1 = D || Col2 <> E && Col3 = F   I want to use these criteria to filter a table. I ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

 

I get this error:

 

Feedback Type:
Frown (Error)

Error Message:
Object reference not set to an instance of an object.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

 

Sorry I still do not understand what you are doing.

 

I have a table already that I want to apply the filter on.  I do not want to create another table. If I do need to create another table, I do not want it to be visible.

 

So I already have the table:

A, A1

B, B2

C, C3

D, D2

E, E3

 

I only want to create a slicer visual.

The slicer visual will need to have two values.

One value is: Show the Table rows where Col2 contains "2"

The second value is: Show the Table rows where Col2 contains "1"

 

These are the only filters I want to be visible in the slicer visual.

 

Can you advise what I need to do step by step please, assuming nothing as known?

 

Thanks!