Forum Discussion

Simon_Lou's avatar
Simon_Lou
Icon for Advocate IV rankAdvocate IV
9 years ago
Solved

Documentation regarding Wildcard Characters

Hi there,

 

I'm looking for some documentation using '*' and '?' in the Visual, Page and Report filters area in Power BI Desktop.  I stumbled across the use of them whilst exploring Power BI and I just need to read and understand their properties.

 

Many thanks,

 

Simon

Data Modeling

3 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Simon_Lou

     

    AFAIK, there is no official document about using ‘*’ and ‘?’ in the filters area. You can use the “contains” in Advanced filtering instead.

     

     

    Best Regards,

    Herbert

    • Simon_Lou's avatar
      Simon_Lou
      Icon for Advocate IV rankAdvocate IV
      9 years ago

      v-haibl-msft

       

      Hi Herbert, 

       

      I have been using "contains" in Advanced Filtering. And within that I can use '*' for one or many characters or '?' for one and one only character.  For example, if I was searching for my name in a record I could search 'S*n' or 'S???n' using contains.

       

      I stumbled upon these characters by a lucky guess, so I wondered at which update this began so I can clarify their use.

       

      Many thanks for your help so far!

       

      Simon