Forum Discussion
Org Chart with Dynamic Tooltip
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.
2 Replies
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.
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!
