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 thanks but unfortunately I cannot open your test.pbix, it displays an error and it closes

 

From what I understand, I will need to create both one table and one measure, is that right?

 

Can you paste please the code for the two and I will try to figure out.

 

Thanks!

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!