Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am quiter new with PowerBI. I am facing an issue about text data that need your help.
I get data from an ODBC connection, and here is the data preview in my QueryEditor:
As you can see here, i have 3 different users.
But after data is loaded to the report, i lower the first letter of the second user (from H0021126 to h0021126). So i got only 2 users, which caused wrong report result.
Is there any way to fix this issue? Thank you.
@Anonymous not sure what your question is? What do you want? Unique list of users? Why you made the h to lower case?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi Parry,
Actually i don't want the H lower case. PowerBI made it automatically, so it caused my report error.
@parry2k wrote:@Anonymousnot sure what your question is? What do you want? Unique list of users? Why you made the h to lower case?
@Anonymous but in your post you mentioned that you made the h lower case for 2nd product. I'm still not sure what you actually looking for, if you can provide sample data in excel and the actual issue you have, it will help.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Sorry that was a miss typo. I meant "It lower the first letter of the second user"
The data source is very simple, i don't know how to upload it here. Please use this table as source:
USER_NAME |
h0021126 |
H0021126 |
user.lds |
Expected result in PowerBI data is the same with source. Current result is:
@Anonymous can you share pbix file by link to one drive/google drive.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous you have to share excel file as well.
what I'm looking thou?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous i guess what you are saying is that if you put users on table visuals, it shows only two users instead of 3 like below, i don;t there is anything can be done, this is how PowerBI work, it aggregates the data on unique columns you put in visual, in this case even two use has different lower/upper case, it comes up as one user
what you are trying to achieve thou?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k Yes i know it aggregates data on unique column. But in fact, h0021126 and H0021126 should be consider as 2 different users. The question is why in source data, i have 3 unique values, but after loading into powerbi without any transformation, what i receive is 2 unique values.
@Anonymous it is not case sensitive, so treating those both as one value
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k so is there any way to make it case sensitive? Because not only in data visual but also in Data Tab, it automatically lower the H letter.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |