Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Simon_Lou
Frequent Visitor

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

1 ACCEPTED SOLUTION

@Simon_Lou

 

You can keep an eye on following document. Power BI will list the new added functions in each release there. If wildcard characters are officially supported, it should be mentioned there.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-latest-update/

 

Best Regards,

Herbert

View solution in original post

3 REPLIES 3
v-haibl-msft
Employee
Employee

@Simon_Lou

 

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

 

Documentation regarding Wildcard Characters_1.jpg

 

Best Regards,

Herbert

@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

@Simon_Lou

 

You can keep an eye on following document. Power BI will list the new added functions in each release there. If wildcard characters are officially supported, it should be mentioned there.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-latest-update/

 

Best Regards,

Herbert

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.