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 agai...
  • 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.