Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

[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

    • Anonymous's avatar
      Anonymous
      Not 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's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity 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.