DAX auto modified text to lower case when it is not necessary

[dobregon]

Hi,

I have found and strange thing in the powerBI, i have 2 lines
A) TOTAL OFFICE COST

a) Total office cost

Same name (but one in upper case). In reality is a table with 2 ids and these 2 names. The problem is when i see in the Transform data, i can see with this format, but when i do the refresh , i see both in lower case. So, i dont understand why PowerBI is modifiying the format of the text.

I'm thinking that probably as it is exactly the same text but with upper case, it is changed in order to show similar but i dont want this.

To solve this i tryied to create a concatenate column with id+name

55-A) TOTAL OFFICE COST

47-a) Total office cost

And then create a calculated column that take all the text after the "-", but when i do that the powerbi show a) Total office cost for both lines when i dont want. 

Can someone help me on this?

Regards

[amitchandak]

@dobregon , In power query you have function Text.Proper, that you can use and convert that into title case.

Also if they are from two different table. You might need common dimesion to show data together

[dobregon]

@amitchandak  thanks for the reply

I know the convert option but i dont want to convert nothing, i want to see as i hve in the database, not that the PowerBI autodetect that it is same text and put as lower case. 

It is same text but different line so i dont want to be converted.

[v-yiruan-msft · Accepted solution]

Hi @dobregon ,

This is by design. Power BI workbook uses a case insensitive language setting. As a result, string in the same column which differ only by cases will be consolidated into a single string depending on whichever happens to be imported first. Query Editor UI displays the strings in the original case before the Import, Data View shows the strings after the Import. You can try the workaruond which provide in the following link:

Data Modeling Uppercase and Lowercase issues

Best Regards

[dobregon]

Thanks @v-yiruan-msft