Upper and Lower Case Text not being displayed correctly in Filter

[ERing]

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.

[OwenAuger]

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:

• https://www.sqlbi.com/articles/letter-case-sensitivity-in-dax-power-bi-and-analysis-services/
• https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/

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