cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anileshknpowerb
Helper III
Helper III

How 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

1 ACCEPTED SOLUTION
az38
Super User II
Super User II

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/

 


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

4 REPLIES 4
Coordin8
New Member

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:

Coordin8_0-1614089798988.png

However, within DAX, it looks like this:

Coordin8_1-1614089798990.png

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

amitchandak
Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

luapdoniv
Resolver II
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.

az38
Super User II
Super User II

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/

 


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.