Sanjay Shah, Pune, India on 24 Dec 2014 20:41:01
Hi, I have used Powerview extensively. Pivot table connected to a Tabular Model is today the best available tool for pivoting. Nothing to beat it. howevere powerview and pivot tables are not integrated to each other, i.e. they do not share the same parameters. The filters I have selected in Powerview shold also filter (optionally) a pivot table also.
Administrator on 11 May 2017 06:48:08
Over the last few months, we've made a lot of progress on a new matrix visual that supports cross-highlighting, stepped layouts and drill. Learn more about the new matrix preview here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-matrix-visual/
- Comments (75)
RE: Integrate Powerbi with Pivot tables
Pivot Table or Multi Dimensional browser the way it was on SSAS 2008 will be great. The current OLAP browser in SQL 2008 R2, 2012 and 2014 don't let you browse by laying out axes. Most of third party developer controls that integrate into Dashboard have an OLAP browsing control (DevExpress, Syncfusion ,etc.)
It is all about Slicing and Dicing in a Dashboard or Report.
RE: Integrate Powerbi with Pivot tables
Yes, it is critical to be able to display data in a cross-tab format like the flexible layout of a pivot table where you can put a dimension on columns or rows, and even nest multiple dimensions on columns or rows.
RE: Integrate Powerbi with Pivot tables
I think it would be great to have a Pivot Table option on the Power View menu. There is a Table option, but that doesn't have the indentation and collapse/expand options that a Pivot Table has.
This is especially relevant for Power BI Version 2 because it seems to be all Power View at this point, no more embedded Excel with Excel Services. I like it because there is no more spreadsheet, but if I could just get my Pivot Tables back then I would like it even more.
RE: Integrate Powerbi with Pivot tables
Business people want to scroll through pages of figures for day to day details. That is why the pivot table functionality is so important. Ideally, you could just deploy an Excel workbook to Power BI that connects to the onprem ssas.
RE: Integrate Powerbi with Pivot tables
I believe that the Excel Pivot Table is a jewel in the crown. the ease with which a mass of numbers can be seen, scrolled up/down, drilled up/down etc.. subtotals, formatting, conditional formatting etc... is something which is not available in any BI tool. Many of my users are more familiar with numbers than graphics (esp the hard core accountants). What we need is a mechanism by which powerview and pivot table can coexist. it is practically impossible to emulate pivot table functionality in any grid of powerview. So instead of reinventing the wheel, why don't you share parameters between powerview and pivot table ? For example if I have selected a country in a powerview map, the pivot table (which may be designed to show a considerable amount of drill down data0 should filter to the selected country. of course whether to link the two should be an option available to the user. I would like to show you some of these use cases.