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 ...
Data Modeling
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