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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

How to make Search option as Case insensitive in Power BI slicer (Direct query)

Hi,

 

I am using direct query approach in my report. Search option is case senstive in my report

how to make this search option as case insensitive in my report ?

 

I have read this Article but not sure how to solve my issue

https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/

1 ACCEPTED SOLUTION
collinq
Super User
Super User

Hi @Anonymous ,

 

Power BI is always case sensitive to my knowledge.  There is an idea to change this here:

https://ideas.powerbi.com/ideas/idea/?ideaid=a9843990-64f6-ea11-b5d9-281878bdaa58

 

I use two different work-arounds for this.  I will make the entire column one case (all uppercase) and that solves it.  But, that isn't always the way I want to the data to be presented so sometimes I will create a second field, make it all uppercase, use that new field for the search and then only display the original version.  Again, not perfect but it works in some situations.

 

I also found this article that gets around it with some M code:

https://www.thebiccountant.com/2016/10/27/tame-case-sensitivity-power-query-powerbi/

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

Since you are working with the direct query mode, I'd like to suggest you consider using T-SQL statement to append a custom field that used to upper/lower case the values of the specific fields.
After these steps, you can directly search for new fields without worry about case sensitive scenarios.
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
collinq
Super User
Super User

Hi @Anonymous ,

 

Power BI is always case sensitive to my knowledge.  There is an idea to change this here:

https://ideas.powerbi.com/ideas/idea/?ideaid=a9843990-64f6-ea11-b5d9-281878bdaa58

 

I use two different work-arounds for this.  I will make the entire column one case (all uppercase) and that solves it.  But, that isn't always the way I want to the data to be presented so sometimes I will create a second field, make it all uppercase, use that new field for the search and then only display the original version.  Again, not perfect but it works in some situations.

 

I also found this article that gets around it with some M code:

https://www.thebiccountant.com/2016/10/27/tame-case-sensitivity-power-query-powerbi/

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors