Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
PaulPalkowski
Helper II
Helper II

Case Sensitivity

I need/want to maintain Case Sensitivity when creating reports. 

It seems that PowerBi now changes the case on my excel data source as seen on this table visual

How can I fix this?

excel.pngtable visual.png

 

1 ACCEPTED SOLUTION

Power Query is case-sensitive, that's why you can add an index there to protect your sensistivity since Power BI is case-insensitive. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

7 REPLIES 7
PaulPalkowski
Helper II
Helper II

Thank You!

You're welcome!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





HarishKM
Power Participant
Power Participant

@PaulPalkowski Hey,
Kindly refer below webpage.

Power BI: How To Transform Data To Uppercase (quicklylearnpowerbi.com)

 

or 

you can go power query 

select column => transform => you can select "capitalize each word"
to get all word as same in your excel.

 

Thanks

Harish
Did I answer your question? Mark my post as a solution!

no, i want to keep the data as entered... What I shared was only an example. What I have is product assignment naming conventions such as 1524E-PP and 1524E-pp where the PP means it has been inspected and the pp means it has not. The are many variations such as e1487-c is aprototype but e1487-C is and approved part. The letter's case in the hundreds of part numbers represents various stages.

audreygerred
Super User
Super User

Hello! The main engine of Power BI is case-insensitive. However, you can create a workaround for this by creating an index for the different case values in Power Query because case-sensitivity is recognized there. Here is a blog that should help explain in more detail: Letter case-sensitivity in DAX, Power BI and Analysis Services - SQLBI





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





I thought at one time, case sensitivity was not auto-corrected in PowerBi . Did this change or perhaps I am thinking of relationships between tables or some other element.

Power Query is case-sensitive, that's why you can add an index there to protect your sensistivity since Power BI is case-insensitive. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.