http://i.stack.imgur.com/5z5Hr.png
I have a dataset which I have simplified a bit for this post. From the image above you can see that I have two data tables. They essentially list the estimated output from two 'facilities', and the actual (measured) output. For this case the measured output is somewhat random while the estimated output is monthly.
What I would like to do is create a PowerPivot chart based on the two datasets, formatted as the example chart in the picture. This way I could switch between different facilities and compare the estimated- and measured output for each facility, either by a filter or a slicer.
I believe it is the first column, 'facility', that creates the problem. Because when I try to link the two tables in the Data Model I get the following error message. 'The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values.'
Any suggestions to what I can change to achieve the PivotChart I explained? I am fairly new to PowerPivot so I greatly appreciate any input.
I have a dataset which I have simplified a bit for this post. From the image above you can see that I have two data tables. They essentially list the estimated output from two 'facilities', and the actual (measured) output. For this case the measured output is somewhat random while the estimated output is monthly.
What I would like to do is create a PowerPivot chart based on the two datasets, formatted as the example chart in the picture. This way I could switch between different facilities and compare the estimated- and measured output for each facility, either by a filter or a slicer.
I believe it is the first column, 'facility', that creates the problem. Because when I try to link the two tables in the Data Model I get the following error message. 'The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values.'
Any suggestions to what I can change to achieve the PivotChart I explained? I am fairly new to PowerPivot so I greatly appreciate any input.
