Forum Discussion

pbiinterel's avatar
pbiinterel
Frequent Visitor
1 year ago

Org Chart for multiple companies with slicer filter

Hi   I am trying to create a Org chart for multiple companies and use this for our company. In order to use that I also need to multiple filters such as region,segment etc.   But the org chart do...
Need Help
pbiinterel's avatar
pbiinterel
Frequent Visitor
1 year ago

HI

 

The issue is not with the user view. We have a marketing database where we have different potential customers. The org chart is for those companies. The filters I need to break that data. For example I am looking for all Hilton hotels in London in luxory segment and then I should get the org chart for that 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi pbiinterel ,
    Thank you for the follow-up.I would be happy to assist you!

    The issue is that when you filter by region, segment, or company (e.g., Hilton hotels in London, Luxury segment), Power BI removes any rows that don’t match the filter,so if a manager doesn’t meet those criteria, they’re excluded and the org chart breaks. To fix this, you may use a DAX PATH() function to create a manager chain, then build logic to include not just the filtered employees but also their full reporting paths. This preserves the org hierarchy while still reflecting your filters in the visual. Let me know if you’d like help with the DAX setup.

    I hope this helps.If so,consider accepting it as solution.

    Regards,
    Pallavi.