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.
Hello,
I am fairly new to PowerBI but I am working on importing our helpdesk information into PowerBI so I can review data trends. The issue I am running into right now is that when i pull in the data from SQL it has a column called "Assigned Users" in the main ticket table. The format of that column is odd (ex. |3||456||23||6|) in that example each number is an employee ID. I have another table that has the employee ID and their name. I took the weird formatted table and duplicated the tickets table and removed all of the columns except the request# and the assigned to column then proceeded to manually strip out just the employee IDs into separate columns, then recombined them into a single All Assigned column where their name is separated by commas.
When i filter by a single name it only returns the rows that have a single name in it.
example,
Request#|Assigned|
1234 | John Doe, Jane Doe, Phil Doe, Play Doe
4321 | John Doe, Play Doe
6785 | Play Doe
If i filter by Play Doe I want it to return all 3 rows, but when i filter the way i have it setup it only returns the solo line where the name is alone in the row.
I can provide more information just let me know what is needed. I have read through the previous posts and some solutions are similar but not exact and since I am unfamiliar with this figured I would ask first.
Thanks for any help.
Hello,
I tried following the video and it did not really work. The only way i can get the filter to somewhat work is when i split the column values into their own column User.1 User.2 all the way to use.6. When i set a relationship between my employee table that has their employeeID and name to the User.1 column in the "assigned users" table it filters properly based on that single column but when i try and split by rows it just blanks to table visual.
@pelicanedunn , Two Options you can split the column into rows in power query
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
or create a dim and split it there
The option is explained here
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
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 | |
69 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |