Org Chart with Dynamic Tooltip

[SEC]

Hello! I'm trying to create a visual in Power Bi to reflect our org structure. It would reflect a hierarchy with Offices -> Divisions -> Teams -> Staff Names. I don't like the Viso option.

The decomp tree visual is okay, but it's not allowing me to create a custom tooltip the way I need. I want to have a tooltip that will show narrative fields based on the division I'm hovering over (division overview and division activities). I've tried a bunch of formats for the tooltip visuals (KPIs, table), but it's either only showing me the details for the FIRST division because the data is summarized, or it just lists all the divisions, not filtering to just the one I'm hovering over.

Is what I need possible? As a further constraints, my org limits the custom visuals I can use. 

[v-xiaotang]

Hi @SEC 

Please share some sample data and its expected output, we will then assess whether it is achievable.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[SEC]

I'm looking for an org chart/flowchart visual to show the org structure with the fields in red in the table below.

And then I would like a custom tooltip that shows the data in blue when I hover over the shapes in the visual. So for example, when I hover over Division 1A's shape in the visual, the tooltip will show Division A1's description and activities.

Office Name	Office Description	Division Name	Division Description	Division Actiities	Team Name	Staff Name
Office A	Office A description	Division A1	A1 description	A1 activities	Team A1.1	Staff name
Office A	Office A description	Division A1	A1 description	A1 activities	Team A1.2	Staff name
Office A	Office A description	Division A2	A2 description	A2 activities	Team A2.1	Staff name
Office B	Office B description	Division B1	B1 description	B1 activities	Team B1.1	Staff name
Office B	Office B description	Division B2	B2 description	B2 activities	Team B2.1	Staff name

Thank you!