How to show case insensitive data in powerbi

[anileshknpowerb]

Hi,

I have a table EMPLOYEE that has 3 columns, ID, NAME and SALARY.

In Database I inserted 4 records as shown below.

ID                 NAME           SALARY

--------------------------------------

101               Employee      2000

102               eMployee      3000

103               EMPLOYEE     4000

104               employee       5000

When I create a report in powerbi desktop to show NAME and SALARY, it shows the NAME as "Employee" for all 4 rows. I want it to show as per Database. How to fix this issue?

Thanks

[Coordin8]

I think Chris Webb's BI Blog: Power BI And Case Sensitivity Chris Webb's BI Blog (crossjoin.co.uk) mentions that Power Query is case sensitive whereas DAX is not. So, for example, a table in Power Query will look like this:

However, within DAX, it looks like this:

From which you can see that DAX has ignored the change in case in rows 2 and 5.

[amitchandak]

Check the data in the import view. Is it in the same case as the database.

[luapdoniv]

Using the ID should resolve your issues. Can you share the output you are seeing now.

Maybe it's coz of the summarization level.

[az38 · Accepted solution]

Hi @anileshknpowerb 

Infortunately, Power Bi and DAX are case insensitive.

you could use workaround from here https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/