[Help] Suggest an appropriate visualization to create a Power BI report

[Anonymous]

Hi All,

I want to create a visualization for the following requirement. But, I am unable to find the right visual. It could by Microsoft or third any visuals as well. Anything would work.

Requirement:

I have a calculation in an excel sheet1 which is referring values from sheet2 and sheet3.

Another calculation is derived by using the values from the same sheet1 and sheet4.

For the above requirement, I would like to create a dependency visual - it could be anything like a organization view or hierarchial view etc.

Thanks!

[v-yalanwu-msft]

Hi, @Anonymous ;

Can you share a simple simple? And the relationship between the four tables, the structure of each table, and the desired output? Maybe measure can be used in PowerBI.

It makes it easier to give you a solution.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You can create columns across tables 

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[Anonymous]

Here, I do not know the related columns in other sheets. So is the reason, I want to build a tree visual showing the dependecies of each sheet.