Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Charuta
Frequent Visitor

Decomposition Tree Structure for Data Mapping - Relationships and Dependencies

Hello - Can someone please help me with the below query 

I have a decomposition tree visual in the report and wanted to show data mapping for the different relationships - dependencies, blockers etc - what I am able to show is as below - 

 

D_tree1.JPG

the left side table is my source data, and the decomposition tree is the visual representation. However the view visible now is only A blocked by B - but we also have B blocked by D, is it possible to get that added in here? 

What we want to see is the whole picture together 

A - blocked by - B - blocked by - D

or in case of C

C - blocked by A - blocked by - B - blocked by - D

 

Data source used is SQL.

The ID is combined primary key for all 3 columns together and we do have another master table that has a primary key for the source and destination columns

 

Thanks in advance

2 REPLIES 2
lbendlin
Super User
Super User

Have you considered using a Sankey diagram instead?

Thanks for the reply..

I tried using Sankey, but somehow it does not give me the a readable view - as the number of records are more.. 

Also for the Source and Destination - we can add only 1 field each, is there a way to add a hierarchy in the destination field? can we traverse, any other options to format/customize?

Another note to add - all I have are the dimension fields.. there is no number/measure value as such. Is there any other visual that we can consider for such views?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.