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.
Currently I have a table that shows the Organizational Unit that a computer is located in. The text displays as something like CN=ComputerName,OU=Group,OU=Blah,DC=Domain,DC=COM
Is there a way that I could get the table to display only as the "OU=Group" and hide the rest of the text in a visual?
I know that if I could somehow find a table that contained the AD container names I could just create a relationship, but I currently don't have one.
Solved! Go to Solution.
Hi @Jakuza
You could split the column in the Query Editor on the comma into rows and then split again on the = sign as one approach.
And then filter the new collum on OU=Group
Hi @Jakuza,
As I tested, solution @Phil_Seamark postedcan achieve your requirement, please feel free to ask if you have other issue. If you have resolved your problem, please mark the helpful reply, or share your own solution.
Best Regards,
Angelia
Hi @Jakuza
You could split the column in the Query Editor on the comma into rows and then split again on the = sign as one approach.
And then filter the new collum on OU=Group
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |