Stack Overflow
Stack Overflow

Questions tagged [powerview]

Power View is a visualisation and prototyping tool created by Microsoft and released as part of SQL Server 2012.

Power View was designed to bring visualisation and analysis capability to end-users, rather than relying on specialised database/business intelligence developers to create reports.

It is based on Microsoft's existing SSRS technology and hosted via SharePoint 2010. PowerView reports are constructed on top of pre-existing data models built using either PowerPivot or the new SSAS Tabular model.

Power View itself presents users with a Silverlight front-end, allowing quick drag and drop functionality to build charts, tables and other visualisations in a matter of seconds. The data structure is exposed in an almost identical manner to Excel's PivotTable/PivotChart functionality.

The initial release of Power View requires SharePoint 2010 as a host for both the Power View and the underlying data model, although Office 2013 also includes built-in Power View capability, using a more advanced version of the tool. Power View reports can also be exported from SharePoint into PowerPoint presentations, and manipulate data live therein.

Further Reading

104 questions
0
votes
1 answer

How can I capture PowerView image?

I am generating Excel PowerView dashboards. I thought it would be useful for users that only want a quick view to see a screenshot of the dashboard, with a link where more analytical people can download the excel file to repivot or drill down to…
Amit Kohli
  • 2,860
  • 2
  • 24
  • 44
0
votes
1 answer

How do I make an Excel Pie chart, with slices each a % fill for another metric?

I am trying to make a pie chart with market breakdown, and then my companies role in each market. So the market has buckets with percentages for each slice, and I want to shade or sub divide each slice accordingly to what my company owns. Thanks so…
phentrus
  • 29
  • 3
  • 11
0
votes
2 answers

Creating a slicer using DAX in PowerView

I am working to make a dashboard in MS PowerView but having some trouble creating "slicers" for my dashboard. A slicer is basically a filter for the whole dashboard which filters out the whole display based on what is selected. For example, I am…
spazzykitten
  • 1
  • 1
0
votes
1 answer

Power View Excel, Showing more than one variable data in world map

I have a table with country and two more columns, like production and consumption. I am using Powerview to show the data in World Map, Is there any way to show both these data simultaneously (different color code). At present at one time iam able to…
meetesh goyal
  • 71
  • 1
  • 4
0
votes
1 answer

PowerBI hierarchy creation without the cloud

Right now we can create hierarchies in PowerPivot but I'm pretty sure I can't do it in PowerBI. I could create a Data Model in PowerPivot and use that for PowerBI I think. Is there any other work around that could be more desktop based? Thanks! …
uh_big_mike_boi
  • 3,350
  • 4
  • 33
  • 64
0
votes
1 answer

How to create Power View report tiled by multiple KPIs?

I am trying to create a Power View report tiled by KPIs, is this possible? An example of my raw data: Company ID Employee ID Measure numerator denominator 1 01 1 2 5 2 04 …
Holy Name Scribes
  • 29
  • 6
0
votes
1 answer

Change the color of legends in Charts in power View

Is it possible to change the color of the legends in Power View charts? i have been googling for some time now but could find a way. I could make use of KPIs to have an indicator as in this link:…
perplexedDev
  • 857
  • 4
  • 17
  • 49
0
votes
1 answer

Slow down timeline in Pivot View

I have been using timeline in Pivot View in Excel 2013. In the play axis I have place year. The timeline rolls very fast such that I even cannot get an idea about how the data is changing over the years.
user1606651
  • 17
  • 5
0
votes
2 answers

What is the maximum file size supported in Excel for PowerView Report

I need your help for the below listed question. What is the Excel file size limit to render Power View Report in Excel 20013? Can we create Power View Report without including model data into Excel 2013? Thanks in advance.
Jay Doshi
  • 330
  • 2
  • 5
  • 19
0
votes
1 answer

Power BI Office 365 - Forecasting - Don't see dot and Analysis tab on the right side

I have created a single line chart power view report sheet and uploaded to Office 365 Power BI app. Then I have enabled HTML5 view, but I am not getting 'dot' for forecasting and not even analysis tab on the right hand side tab with filters. Is…
Mittal Patel
  • 808
  • 1
  • 22
  • 37
0
votes
0 answers

Power View Error - an item with the same key has already been added

I need a solution in resolving an error which pops out in Microsoft Power View. After creating the model using Excel Power Pivot without any linkage errors, I tried to create Power views from the model. But it pops out the there as: an item with…
Prabhu Ramamurthy
  • 1
  • 2
0
votes
0 answers

How to refresh Power View sheet connected to a Tabular Model after making changes on Visual Studio

SOLVED: apparently this was due to a connection issue w my tabular model. I had to rebuild all of my existing tabular model connections to get everything to refresh properly. I'm currently working with a power view excel sheet that's connected to…
AppleTuna
  • 1
  • 3
0
votes
2 answers

Top 5 and Bottom 5 records in Power Pivot

I am trying to show top 5 records and bottom 5 records in two separate tables in Power View. I have created a calculated measure to show the records. But it doesnt giving me the required result. My Data Set is:- ID Name Rating OverallRating …
BIDeveloper
  • 767
  • 3
  • 14
  • 28
0
votes
1 answer

Excel Power View Date Slicer

I am trying to create a date slicer in Excel Power View. My query is pulling from Salesforce to show data from the past 60 Days. I would like to create a slicer to only show data for Past 7 Days, Past 30 Days, and Past 60 Days. This is easy to do…
CCOdmm
  • 5
  • 3
0
votes
1 answer

Excel web access web part loading twice

I have an excel workbook which contains Power View sheet which I want to include in my SharePoint online site. So I used excel web access web part to include the Power View chart. But the problem is the chart loads twice. And the performance is…
ssingh
  • 294
  • 1
  • 4
  • 19
1 2 3 4
5
6 7