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

hysen on 05 Jul 2020 22:06:43

RE: Integrate Powerbi with Pivot tables

When Power BI will integrate the Excel pivot table feature, then will really be called POWER BI

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

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

RE: Integrate Powerbi with Pivot tables

Do not understand this, one of the best excel feature, is not available in PowerBI :-(

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

Tim Rodman on 05 Jul 2020 22:02:24

RE: Integrate Powerbi with Pivot tables

Are pivot tables included in what is mentioned here?

https://twitter.com/rquintino/status/623444409753948160

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

Eduardo Godyla on 05 Jul 2020 22:02:23

RE: Integrate Powerbi with Pivot tables

Many other analytical dashboard products include pivot analysis in their dashboards

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

Tim Rodman on 05 Jul 2020 22:02:07

RE: Integrate Powerbi with Pivot tables

According to the latest slam dunk post from Rob Collie at http://www.powerpivotpro.com/2015/07/power-bi-designer-vs-excel-whats-microsoft-up-to/, we're about to see Excel Services get added to PowerBI.com. If that happens, this Pivot Table issue will be solved in my opinion.

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

Vikas Pulpa on 05 Jul 2020 22:02:07

RE: Integrate Powerbi with Pivot tables

I want to create a pivot table report and display it on the power bi. Today when I create the pivot table report along with power view reports and import this into power BI, I am not able to view the pivot table report. Basically pivot table report gives us much more functionality compared to the table report in the power BI

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

Power BI User on 05 Jul 2020 22:02:06

RE: Integrate Powerbi with Pivot tables

Pivot Table functionality is a MUST

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

Alexander Lyskovets on 05 Jul 2020 22:02:06

RE: Integrate Powerbi with Pivot tables

Reall-really need Pivot tables functionality in Power BI!

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

Stephen Thomas on 05 Jul 2020 22:01:51

RE: Integrate Powerbi with Pivot tables

Do you have any update on this? It looks like it has been under review for quite some time.

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

Marc.Lim on 05 Jul 2020 22:01:45

RE: Integrate Powerbi with Pivot tables

Ability to customize tables. example placing Time Periods as columns like Pivot Tables. This is a key requirement. Keeping Time Periods as Row only in tables takes up too much space as well.