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
1
vote
1 answer

Sort chart legend in PowerView

I'm playing about with PowerView at the moment and have run into a slight issue. I've got a line chart (below) but would really like to sort the legend (Keyword) depending on the latest value of the data point in the chart (currently sorts…
GShenanigan
  • 5,409
  • 5
  • 38
  • 48
1
vote
1 answer

Power view layout issue

Anyone developing on power view? I have a slicer on the year but I would like to display it in X columns instead of X rows. Its kind aeasy to do it on power pivot but I cant figure it out how to do it on power view. Is it possible?
Diego
  • 34,802
  • 21
  • 91
  • 134
0
votes
0 answers

How to create one-to-one relationship in Power View (Office 365)?

I need to create a one-to-one relationship in my PowerView data model. I see it was not available previosly, but now it is: In a data model, table relationships can be one-to-one (each passenger has one boarding pass) or one-to-many (each flight…
Poliakoff
  • 1,592
  • 1
  • 21
  • 40
0
votes
1 answer

Column order in PowerView

I have following sample data in PowerPivot: id name type color 1 aaa x blue 2 bbb y red 3 ccc x blue 4 ddd y orange 5 eee z black When I create pivot table in Excel and…
Juraj C
  • 97
  • 1
  • 12
0
votes
1 answer

Averaging percentages across filtered groups in Power View

I import data into Excel using Power Query, where I add a new column to calculate a usage percent. I then want to use Power View to visualize this data. However, when applying filters on the data and wanting to view the average usage percent across…
Sean
  • 133
  • 1
  • 5
0
votes
1 answer

Advance Excel chart, scatter chart with multiple axis value with time lapse

I have 7 different measurement points on which is temperature measured for every hour (timestamp). Like these pic down. I want graph similar like these. Data table: timestamp m1_temp m1_dist m2_dist m2_temp Mar 9, 2017 12:00:00 AM…
ejovrh2
  • 59
  • 9
0
votes
0 answers

How to Use Vertical/Horizontal Multiples in PowerBI

I am aware that MS Excel 2016 Power View has handy feature of Vertical Multiples and Horizontal Multiples. Here is sample output. How to implement this in PowerBI. Cannot find this feature anywhere. Plz don't tell me we have to manually create pie…
Rhonda
  • 1,661
  • 5
  • 31
  • 65
0
votes
1 answer

Excel power view sheet comes out blank when printing

When I try to print a power view sheet it comes out blank (no ink on the paper), even though the print preview shows the sheet nicely. See image below (secret stuff is blurred out): According to Microsoft themselves it should be possible to both…
Starwop
  • 103
  • 2
  • 12
0
votes
0 answers

Power View - Tables with columns of the similar data

Apologies in advance if my question is obvious but I'm new to this and having spent days searching and experimenting I cannot achieve the result I'm after. I have a big table of data that I want to plot some graphs for, namely stacked columns and…
rmc106
  • 1
0
votes
1 answer

power view with Sharepoint 2016

I am trying to publish sharepoint2016 website including Power View reports which created by SQL server services service (SSRS). there is top level site and bi center as sub-site; both are working fine but problem is that when I try to view the…
Bader
  • 1
  • 1
0
votes
1 answer

How to implement Dynamic Security in PowerView

I have created a PowerView using a BISM connection in Enterprise Portal of AX. That PowerView report will be used by 100+ users. I want every user to his/her data in the PowerView instead of viewing the complete data. One option is to create 100+…
visionet
  • 21
  • 1
  • 5
0
votes
0 answers

Integrate playAxis in custom written bubble charts

I am using the slider for making the bubble chart in motion. Can we Integrate Power View PlayAxis in our Bubble charts using java script.
Raju Rajoriya
  • 23
  • 3
0
votes
2 answers

Display dynamic information in PowerView Report Title

I've a little problem, I've to display the refreshing date in the report title to be "My report title refreshed : Curent date for exemple" I think that the title is a statical object but our client needs this information. Thanks for your help.
Guebailia.abderrahim
  • 1
  • 1
  • 4
0
votes
1 answer

What is the equivalent of Excel's Subtotal in Power Pivot?

Is there a way to count the total number of rows returned in a filtered table in Power Pivot? I tried populating a column with 1 or 0 and used SUM. But it returned the number of rows in the original table and not in the filtered.
Chester Lim
  • 459
  • 7
  • 19
0
votes
1 answer

Sharepoint 2013 PowerView report depending on connected user

I'm working on a power view map to display to our user. I achieved to create a map that display all the data to the user. It look like this exemple. The data source is an SSAS project. But now, I would like to filter this data depending on the…
dpfauwadel
  • 3,866
  • 3
  • 23
  • 40
1 2 3
4
5 6 7