Forum Discussion

romeo95's avatar
romeo95
Frequent Visitor
8 years ago

hierarchical visualization

Hi to everybody, I write you to ask you a suggestion: I have a chart with the business structure, 2 columns with code structure and code it structures superior, like this
UNIT    UNIT FATHER
1    
2    
3        1
4        1
5        2
6        3

 I have my table of the facts with code structure and import sales,
UNIT    SALES
1        10
2        13
3        8
4        26
5        9
6        11

 how can I  get a hierarchical visualization of the data?

thanks

Need Help

5 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi romeo95,

     

    Please create a one to one relationship between these two tables based on [UNIT].

     

    Add corresponding fields into chart visual. You can view hierarchical data by clicking the drill down icon.

     

    Best regards,
    Yuliana Gu

    • romeo95's avatar
      romeo95
      Frequent Visitor
      8 years ago

      hi, I thank you but the solution is not that that I look for, in my scheme 3 are father of 6 but child of 1 but in the visualization it results to the same level of 1 and 2