Forum Discussion
Solved
How to keep case sensitive information for each ID?
I have a dataset of around 20,000 rows, and I would like to keep individual columns' exact values for each unique ID including their capitalization. However, PowerBI will refer to the first instance of the data and use that capitalization format for the rest of the table.
This is an example of my data (which is how I want the data to be):
| ID | First_Name | Last_Name |
| 1 | STEVE | SMITH |
| 2 | John | Smith |
| 3 | SteVE | Smith |
| 4 | Mark | Thomas |
This is how PowerBI default outputs:
| ID | First_Name | Last_Name |
| 1 | STEVE | SMITH |
| 2 | John | SMITH |
| 3 | STEVE | SMITH |
| 4 | Mark | Thomas |
In the query editor, the information is correct. In model view, or in the report, it is as above.
Basically, I would like a way to keep case sensitive information for each row/ID. Any suggestions?
