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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ERing
Post Partisan
Post Partisan

Upper and Lower Case Text not being displayed correctly in Filter

I have a column in my data that contains upper and lower case text of the same name. For example, this column contains both Luxury and LUXURY as well as Entry and ENTRY.
 
The issue is that the slicer is showing both as UPPER CASE, while only allowing the user to select the true UPPERCASE text. This is resulting in the visuals returning fewer data points because only the UPPERCASE text is being selected.
 
Has anyone encountered this or know how to fix it?
 
I've tried converting the column to all UPPERCASE in PowerQuery, but then the slicers gives me a folding error.
1 REPLY 1
OwenAuger
Super User
Super User

Hi @ERing 

The underlying cause of this is that DAX is not case-sensitive in Power BI.

In practice this means:

  • If a table is loaded to the dataset with a column containing values that differ only by case, all of those values will be replaced by a single representative value (typically matching the case of the "first" occurrence).
  • Strings that differ only by case are treated as equal in equality comparisons (but can be distinguished with the EXACT function).

These two articles cover the topic pretty well:

 

In your case, can you check whether multiple capitalizations of the same value were actually loaded to the dataset? I would suspect that either "Luxury" or "LUXURY" but not both would actually appear in the column after loading the table.

 

One suggestion in the 2nd article is to append one or more zero-width spaces (such as UNICHAR(8203) ) to certain text values in order to differentiate them without altering the appearance. You could use some method to index the variations of "equivalent" strings, so that the 1st is left unchanged, the the 2nd has one zero-width space added, and so on.

 

It might be best to solve this in the data source rather than Power Query.

 

Regards


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
LinkedIn

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.