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

Hi Anonymous ,

 

You will need to create a new table with couluns contains measures' name.

Use this table as slicer with following measure.

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

Sample data for your reference.

 

 

Best Regards,

Jay

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