Diagram and hierarchies

[kreuzberg]

Hi all,

I am trying to create an interactive map of data that the company collects in different areas of the business. The company has over 1000 of metric and this map should help it to get better understanding which metric relate to which area.

My idea is to use create a dashboard with the structure of the company, such as:

Where a list of relating metrics would show on side. The idea is that when clicking on e.g. Marekting, only Marketing measures would show. I would also want to have a slicer for the different tags too.

This is illustration of the metrics.

How do I go about this?

[lbendlin]

Use tools that are designed for that, like Collibra or Purview.

[NeZ_AL]

Have you tried to put that diagram in a shapefile? You could created and edited in QGIS after that you exported as GEOJSON, the  you imported to PowerBI and then you could clic each area and you will get the measures that you need.