Active Directory Security Group Structure

[PowerUpDaddy]

Hello! I'm trying to build a visual that shows the relationships between Active Directory security groups. I've pulled the data from AD and filtered it down to include members of each group, but I can't figure out the visualization. I'm imagining something that shows the members of a given group as groups and then a total number of users in each group. 

[Anonymous]

Hi @PowerUpDaddy ,

1. If there are no 【group】 field in the metadata, you can select the bar chart and group the axes manually.

Use grouping and binning in Power BI Desktop

2. Conversely, if the model has a [Group] field that only needs to have a relationship with the user table or be in the same table, you can use [Group] as the x-axis and Count aggregation for [User] as the y-axis.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum