Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 -
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
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?
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |