Forum Discussion
Helper IIIHow to show case insensitive data in powerbi
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
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/
4 Replies
- az38
Community Champion
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/
- luapdoniv
Resolver II
Using the ID should resolve your issues. Can you share the output you are seeing now.
Maybe it's coz of the summarization level.
- amitchandak
Super User
Check the data in the import view. Is it in the same case as the database.
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.
