Forum Discussion
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_SeamarkMicrosoft 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
- LeninFrequent Visitor
Thanks Phil. Much appreciated.