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
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.
RE: Integrate Powerbi with Pivot tables
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.)
RE: Integrate Powerbi with Pivot tables
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
RE: Integrate Powerbi with Pivot tables
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..
RE: Integrate Powerbi with Pivot tables
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.
RE: Integrate Powerbi with Pivot tables
Pivot tables should be in Power BI desktop asap!! Why isn't it in? It's essential.
RE: Integrate Powerbi with Pivot tables
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.
RE: Integrate Powerbi with Pivot tables
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.
RE: Integrate Powerbi with Pivot tables
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.
RE: Integrate Powerbi with Pivot tables
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.