Integrate Powerbi with Pivot tables
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.
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/
Fran McLoughlin commented
I cannot believe that Power BI has not integrated Power Pivot into its matrix.
All of the current report offerings are no more than eye-candy to me.
I "migrated" to Power Bi as I thought it might be an upgrade to Power Bi.
While the memory management issue seems to be under control the report offerings are of no real interest.
I for one would be glad to put my money where my mouth is to push Power Bi up the development list.
"Printing is only available in Power BI service and not Power BI Desktop" - why...
"Reports can only be printed one page at a time -- you can't print the entire report at once." - why...
My clients have a tough enough time accepting BI as its user paradigm is so different from the rest of the MS Suite.
Krishna kishore commented
Kindly integrate pivot tables in power bi... because of these few things which are missing in power bi, we are forced to look at other tools like tableau and spotfire. power bi has got a great potential... but at the same time it is not complete...
Without PivotTable,power bi is nothing.
I can see Pivot Tables in the Power BI sample file Titled "Customer Profitability Sample". When I click on the table, it shows "Pivot Table Fields". I can alter the table, update it, click on fields to include or remove from the pivot. Isn't this an integration of Power BI with Pivot tables? The sample can be downloaded from here: https://powerbi.microsoft.com/en-us/documentation/powerbi-sample-customer-profitability-take-a-tour/
There is no solution in Power BI that is near to the capabilities of the Excel Pivot Table to use ragged hierarchies or to be more specific use Parent/Child dimensions from a Analysis Services Multidimensional Model. Some of my SSAS MD models build eons ago, make use of ragged hierarchies and Parent/Child dimensions. Currently customers that have to rely on these hierarchies, types of dimensions to get some of their analytical questions answered are more than hesitant to give Power BI a chance. And we all know Power BI deserves better.
Are there still no pivot tables?
Dewayne Delk commented
The lack of pivot charts alongside pivot tables is a show-stopper for recommending Power BI to our analysts. This kit is designed to be used for information discovery so it should be able to flip and spin data views even better than Excel. I see each month things being added and they are of little use if we aren't using the software because it lacks the basics
Dewayne Delk commented
and Pivot Charts
Yes, we need this too. Why was pivot table removed in access 2013? Why not include it in power bi? It was such a good control...
Will, to answer your question: "What is it about Pivot Tables that are useful?" It's the summary of values at various levels of a hierarchy and being able to drill in, dynamically to different levels of that hierarchy. Particularly, ragged hierarchies. Pivot tables handle that view much better than Matrix or table visuals.
Nandor Santa commented
I realy like to see the numbers too, a pivot table gives the possibility to colaps columns, and to filter the data when I click on dat from a cretin column.
I used this functionality a lot in QlickView, an even nicer pivot table was introduced with QlikSense.
A pivot table tile in the dashboard would be just extraordinary.
There are several things going on here:
1) Power BI tables are limited and restricted (other visuals are generally much better); Excel is much better at this sort of thing, and so I'd really like to be able to hook an Excel pivot table to a Power BI model, so I can get the best of both worlds - but also get the latest DAX/xVelocity (why in heaven's name Excel and Poser Bi run different versions of this, I dunno, but if that's how it's being done, then I want a way to tie Excel to the models I create in PowerBI)
2) I'd like to be able to create a model in Power BI then download the model offline for use with Excel in situations where I have no access to the cloud, or to the network generally (e.g., in places where security is an issue, on an airplane, etc.)
Ryan R commented
What's important in the pivot table. Being able to:
1) Expand and collapse rows and columns to see summaries and details underneath
2) Being able to double click on the data cell and see the data (or single click and show a pop-up table would be even better)
3) Being able to filter the data in the pivot table based on the data tables field contents
4) Being able to sort the data so see
5) Being able to see add data bars and color scale (excel terminology) to visualize how the data compares to others ones in the column/row
Chirag Agarwal commented
I had voted for this long back and dont really remember when I did so. If I look at this again today, I can do this using the Matrix visualization available in PowerBI Desktop. thanks! removing my votes for this..
PLEASE VOTE for this one and the one noted below if you have enough votes.
This is related to another issue that currently have almost the same amount of votes: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-values-on-rows-instead-of-colum
These are several "ideas" posted for this feature set (all couched a little differently but essentially the same). The Matrix visual is helpful but does not have enough features to make it very useful, especially when looking at data over time (YoY, month to month, the fiscal year for P&L, just to name a few. Even adding some of the more basic parts of 'pivot table' functionality would greatly enhance this and fulfill a need that many are requesting.
This is a huge gap right now. Please tackle this one.
Egbert Jan commented
Pivot tables should be in Power BI desktop asap!! Why isn't it in? It's essential.
We were searching for a Pivot table chart and it is surprising that power BI does not have that. We are rebuilding reports that have already been built using Oracle VA and SAP VA. The pivot is available in these others. Why power bi does not have them yet.
Randy Volters commented
Pivot tables in reports are often called cross tab reports. Not everything in BI can be 'visualized'. Sometimes a summary of data is required by executives and cross tab (pivot) tables are needed. Another way to say it is this - Without a native pivot table ability in the Power BI Desktop, it will not be as successful as it otherwise could be. Waving at Excel and speaking of importing a pivot table from Excel into Power BI is just not a solution. Put a Pivot table capability in the Power BI deliverables and you'll get more interest.
Pivot tables in Excel against an OLAP source work great: They can be formatted various ways, with lines, colors, conditional formatting, and so on. The Power BI table is very limited and hard to read. It would be great if we had at least a little more control over how data gets displayed in a Power BI table.
I don't advocate, however, building it out to the point where it works like Excel. Rather, we should simply be provided with a way to drill across to an SSRS report, or to Excel Online.
Jordan Fox commented
Absolutely need pivot tables to drive a P&L like report, supported by the visual dashboards. It's a requirement, financial people like to look at numbers and currently the matrix doesn't fit the bill. We need pivot table like support.