Forum Discussion

GreenR1's avatar
GreenR1
New Member
2 years ago
Solved

Changing Slicer Search type

I'm using a Slicer but the default setting is to search for data "Contains", is there a way to change this so that data is searched on "Starts With".

 

Reason for this is that we are searching against MAC addresses and having the default behaviour is pulling back too much information.

I cannot see or find a way to change the default search type.

 

thanks
Richard

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

     

    Thanks for the reply from bhanu_gautam , please allow me to provide another insight:

    Hi, GreenR1 

    Regarding the issue you raised, my solution is as follows:

    1.First I have created the following table and the column names and data are the data you have given:

    2.Then we create the following calculated columns as slicers: 

    Column = LEFT('Table'[value],2)

    3.Here's my final result, which I hope meets your requirements.


    4.Of course, you can use custom visuals like this: 

    5.Here's my final result, which I hope meets your requirements.

    Please find the attached pbix relevant to the case.

     
    Of course, if you have any new ideas, you are welcome to contact us.
     

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.




     

6 Replies

  • GreenR1's avatar
    GreenR1
    New Member
    2 years ago

    Thank you for that, i'll have a look at these suggestions

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi,GreenR1  

      Thanks for the quick reply.
       

      Looking forward to your latest reply.
       

      I wish you all the best in your life.

       
      Of course, if you have any new ideas, you are welcome to contact us.
       

      Best Regards,

      Leroy Lu

  • GreenR1's avatar
    GreenR1
    New Member
    2 years ago

    Thanks, whilst not perfect using the Test Search slicer has provided an acceptable solution.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

         

        Thanks for the reply from bhanu_gautam , please allow me to provide another insight:

        Hi, GreenR1 

        Regarding the issue you raised, my solution is as follows:

        1.First I have created the following table and the column names and data are the data you have given:

        2.Then we create the following calculated columns as slicers: 

        Column = LEFT('Table'[value],2)

        3.Here's my final result, which I hope meets your requirements.


        4.Of course, you can use custom visuals like this: 

        5.Here's my final result, which I hope meets your requirements.

        Please find the attached pbix relevant to the case.

         
        Of course, if you have any new ideas, you are welcome to contact us.
         

        Best Regards,

        Leroy Lu

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.