Forum Discussion

PowerUpDaddy's avatar
PowerUpDaddy
New Member
3 years ago

Active Directory Security Group Structure

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. 

Need Help
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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