I created a dashboard setup of about 20 charts and tables using powerpivot from SQL database. I have about 15 relationships set up and I am currently recieving a phontom row label in my pivot table. I check the powerpivot data and the tables that I have connected to the pivot chart is proper. There are no blanks but for some reason it's including a phantom row label. The query includes 4 cases "Streamline", "DTI <40", "DTI 40-50", and "DTI >50" and all the rows fall in under those 4 cases. However it's inputing a phantom row. Any Ideas???

hi, Check the link below to see how to manage Pivot Chart. Hope this will help. http://technet.microsoft.com/en-us/library/gg413436.aspx http://wiki.softartisans.com/display/RS40/Working+With+PivotCharts

hi, Check the link below to see how to manage Pivot Chart. Hope this will help. http://technet.microsoft.com/en-us/library/gg413436.aspx http://wiki.softartisans.com/display/RS40/Working+With+PivotCharts

Hi, If there will be any NULL valued record and you have not handled it in your expression then it will not fulfill any of your 4 cases i.e. "Streamline", "DTI <40", "DTI 40-50", and "DTI >50".Aftab Ansari

Hi, If there will be any NULL valued record and you have not handled it in your expression then it will not fulfill any of your 4 cases i.e. "Streamline", "DTI <40", "DTI 40-50", and "DTI >50".Aftab Ansari