Thursday, April 12, 2012 3:43 AM
We are going to try and use Power View to present some polling data at a BOD meeting next week. For the most part we have been successful and happy in getting what we want. However I want to share a couple questions and feedback on issues we have run into.
- Custom sorting is hard if you start with a csv download. It requires that you create a second table and link it to the main data table. This should be easier. Example sorting Strongly Approve, Approve, Neutral, Disapprove, Strongly Disapprove in that order.
- Percent of total is also a serious challenge. There should be an easy way of doing this just like in Excel Pivot tables. Getting percent of total required an extra measure in the model itself and I still haven't found a formula that will give me percent total of say captains who approved of issue A? I feel like this should be easy to do?
- Click to interact and the login/load time mean that you really need to click these things before you begin your presentation.
- The color scheme options leave a lot to be desired. It is impossible to match them to existing PowerPoint backgrounds and if you want to give like answers a similar color, for example Strongly Approve and Approve, it is impossible. Is there a workaround for this?
- "Values" can only be a column chart series and NOT a axis. This is a problem if you want to compare two questions on the X axis. The only workaround is a clustered column chart.
- The font and style on the axis and data labels should have the option to be made bigger. It is hard to read for some even on a 15 foot screen. Is there a workaround for this?
If there is interest you can contact me privately and perhaps we can share a video of the presentation with you.
Monday, April 16, 2012 7:51 AMModeratorHi SWAPA,
Please share the video to us by the following E-mail address:
E-mail: sqltnsp AT microsoft.com
(Please replace the AT with @, and remove additional spaces).
Here are some articles about Power View for your reference:
Power View Overview: http://social.technet.microsoft.com/wiki/contents/articles/3726.power-view-overview-en-us.aspx
What’s New In Power View: http://blogs.msdn.com/b/sqlrsteamblog/archive/2011/11/17/what-s-new-in-power-view.aspx
Power View (SSRS): http://technet.microsoft.com/en-us/library/hh213579(SQL.110).aspx#PresentationReady
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Sunday, April 22, 2012 5:21 AM