Excel 13 Powerview Linking Multiple Worksheets
I created a sample Powerview report in Excel 2013. I created two worksheets. On one of the worksheets i placed some charts and tables and on the other worksheet i placed a map. Is it possible to link the two powerview worksheets. What i wish to do is if i click on say 'India' in the powerview worksheets containing the map, the other worksheets containing the charts and tables also should get filtered. Kind Regards Sanjay
August 28th, 2012 4:50am

Hello, Read the article below. It may help you. http://office.microsoft.com/en-us/excel-help/whats-new-in-power-view-in-excel-2013-and-in-sharepoint-2013-HA102901475.aspx#_Toc332486681
Free Windows Admin Tool Kit Click here and download it now
August 28th, 2012 7:24am

Thank you. It is helpful, but it does not answer my question. I am not able to link two powerview worksheets. for example if in one sheet i am having a chart of country and sales amounts, and on the other sheet i am having a chart of country and Account Receivable amounts. if i select country in one sheet, the other sheet also should get filtered to the selected country. this is not happenning, though both share the same data model. Am i missing something ?? sanjay shah pune, india
August 28th, 2012 12:43pm

Hi Sanjay, Power View provides several ways to filter and highlight data in reports. Highlighting, slicers, and filters filter all the visualizations on a sheet or view, and each other. Currently, none of the filters apply across multiple sheets or views; all are specific to individual sheets or views. This is by design. I recommend that you submit this suggestion at https://connect.microsoft.com/SQLServer/. If the suggestion mentioned by customers for many times, the product team may consider to add the feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided. Thanks for your understanding. Regards, Mike YinMike Yin TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
September 4th, 2012 12:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics