Forum Discussion

KvRalf's avatar
KvRalf
New Member
6 years ago

Wildcard search

Hi,

 

Is there a way to filter fields on several different wildcard? i

For example I want to filter on Material numbers srting with 

A1234*

B23*

C456*

H1234*

The advanced filter allows only 2 of them using "or"

Another wildcard filter solution I would like to find is for "ends with" (like it exist in advanced filter "starts with")

Ay ideas how to get this?

 

thx Ralf

Need Help

4 Replies

    • KvRalf's avatar
      KvRalf
      New Member
      6 years ago

      Hi Nathaniel,

       

      thx for reply. I work in PowerBI.

       

      rg Ralf

      • KvRalf's avatar
        KvRalf
        New Member
        6 years ago

        I tried now as well the PowerBi Visuals 

        "Filter by List by Devscope" and "Text FIlter" from the PowerBI marketplace, but both are limited to what i want to achieve.

         

        So what I'm trying to get is a multiple wildcard selection for several values

        e.g. A131*

        B*12356*

        A15*

        etc.

         

        and and "ends with" filter like it exist in the advanced filter.

         

        rg Ralf

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi KvRalf 

     

    If you 'd like to filter the rows which end with "6*", you can refer to the RIGHT function: 

    Measure = IF(RIGHT(MAX('Sample'[Column]),2)="6*",1)

     Then drag this measure to filter pane, and set it as 1: