Forum Discussion
[Help] Suggest an appropriate visualization to create a Power BI report
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!
3 Replies
- amitchandak
Super User
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- AnonymousNot applicable
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.
- v-yalanwu-msft
Community Support
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.