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