Zoom in/ Zoom out in particular area/ selected area on Charts in PowerPivot

Question

I do have 2 millions of records in the database table, table name is "SalesHistory". This "SalesHistory" table has 10 years old data, and i am using this data on Line Chart. I wanted to zoom particular area (Particular Year/Month/Day), like Bing maps/ Google maps, if you could please let me know how to do in PowerPivot.
Many thanks in advance.

Kind Regards

Answer 1

Hi RP Reddy,

There is no build-in feature for PowerPivot to achieve this requirement, in Power View report, Every visualization has an pop out option, this will show the visualization full screen so you can better look to the details. Press on the Pop In button to go back to the report. So you can zoom in/out to the report item. If possible you can use Power View to workaround the issue.

For more information about Power View (SSRS), please see: http://technet.microsoft.com/en-us/library/hh213579(v=sql.110).aspx

SQL Server Reporting Services Team Blog bout What’s New In Power View http://blogs.msdn.com/b/sqlrsteamblog/archive/2011/11/17/what-s-new-in-power-view.aspx

Thanks,
Challen Fu

---

Challen Fu

TechNet Community Support

Answer 2

Hello Challen Fu,

Many thanks for the reply, i have seen all the options in the Power View as well, but there is nothing about ZOOM to particular/specific area.

I am eagerly looking for the solution, could please provide me suitable solution.Thank you.

Kind Regards

Answer 3

In Power View, there is a button of Pop out, please see below image in the red rectangle:

By the way, this feature is only in Power View rather than PowerPivot, just like the statement in my first reply, there is no build-in feature to achieve this feature in PowerPivot currently, I would recommend you submit a wish to Microsoft Connect at this link at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider adding this feature in the following release after official confirmation.

---

Challen Fu

TechNet Community Support

Answer 4

Many thanks Challen Fu.

I will do so.

And, i am planning to download Dundas chart controls to get zoom to specific area in SSRS, could please suggest me, but i have to do this zoom task, because we will be using this zoom feature for our future projects, so i have sort out this task, your suggestions would be most welcome, thank you.

Kind Regards

Answer 5

For Dundas, it will be better if you can consult your question in Dundas http://www.dundas.com/support/ to receive more specific support. Thanks for your understanding.

---

Challen Fu

TechNet Community Support