Forum Discussion

Lenin's avatar
Lenin
Frequent Visitor
9 years ago
Solved

Display multiple data sets in hierarchy

Hi I was wondering if it is possible for a visual, say a line chart in a hierarchy to show more than one data set? I have a hierarchy that has a structure 

 

Year

   |

   |

   ___Team Name

             |

             |__Resource Demand

 

Within the same table that contains Year, Team Name and Resource Demand I have a "Resource Capacity" column that I would like to display in the same line chart that I display resource demand. Is this possible?

 

Thanks     

Lenin

  • Hi Lenin

     

    Do you mean more than one table?  If so, yes you can simply by dragging extra categories to the Axis field in the Visualization area (you can stack these up).  You just want to make sure there is some form of relationship between the fields (either same table or related table).

     

    In this example I have added Countries and Cities in the Axis 

     

     

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee

    Hi Lenin

     

    Do you mean more than one table?  If so, yes you can simply by dragging extra categories to the Axis field in the Visualization area (you can stack these up).  You just want to make sure there is some form of relationship between the fields (either same table or related table).

     

    In this example I have added Countries and Cities in the Axis 

     

     

    • Lenin's avatar
      Lenin
      Frequent Visitor

      Thanks Phil. Much appreciated.