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
Community Champion
Community Champion

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
Super User

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



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau 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
Community Champion
Community Champion

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

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors