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 can you tell me please what is the below and how do I create it? 

'Table (2)'[slicer]

 

Thanks! 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

It's a simple table contains measures' name as the slicer.

Pbix as attached, hopefully works for you.

 

Best Regards,

Jay

  • 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

      Hi Anonymous ,

       

      avgx = AVERAGEX(ALL('Table'),'Table'[Column2])

sumx = SUMX(ALL('Table'),'Table'[Column2])

Measure = SWITCH(SELECTEDVALUE('Table (2)'[slicer]),"sum",[sumx],"avg",[avgx])

      Table2 is a sample table which i create manually use Enter Data feature.

       

      Best Regards,

      Jay

    • 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!