Skip to main content

Power BI

Completed

Integrate Powerbi with Pivot tables

Vote (556) Share
Sanjay Shah, Pune, India's profile image

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)
Sanjay Shah, Pune, India's profile image Profile Picture

Nandor Santa on 05 Jul 2020 22:27:12

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.

Sanjay Shah, Pune, India's profile image Profile Picture

rgoerwit on 05 Jul 2020 22:24:48

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.)

Sanjay Shah, Pune, India's profile image Profile Picture

Ryan R on 05 Jul 2020 22:24:28

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

Sanjay Shah, Pune, India's profile image Profile Picture

Chirag Agarwal on 05 Jul 2020 22:23:34

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..

Sanjay Shah, Pune, India's profile image Profile Picture

Alison on 05 Jul 2020 22:23:32

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.

Sanjay Shah, Pune, India's profile image Profile Picture

Egbert Jan on 05 Jul 2020 22:22:43

RE: Integrate Powerbi with Pivot tables

Pivot tables should be in Power BI desktop asap!! Why isn't it in? It's essential.

Sanjay Shah, Pune, India's profile image Profile Picture

Power BI User on 05 Jul 2020 22:22:11

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.

Sanjay Shah, Pune, India's profile image Profile Picture

Randy Volters on 05 Jul 2020 22:21:28

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.

Sanjay Shah, Pune, India's profile image Profile Picture

rgoerwit on 05 Jul 2020 22:21:08

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.

Sanjay Shah, Pune, India's profile image Profile Picture

Jordan Fox on 05 Jul 2020 22:20:58

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.