Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
Proud to be a Super User! | |
Thank You!
You're welcome!
Proud to be a Super User! | |
@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.
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
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.
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
68 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |