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

88469823 69ee-4b2e-8c5f-02c46f980caf 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

dde8a556 2928-4d13-b4bc-824b7e39179c 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

9d3a31cb 6cad-47dc-aba8-7382e8e8985d 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

5ed134f8 edd1-4f5e-96d6-5c3c2ec900a7 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

65a98445 53c8-4fb0-bafa-0fa3942a14e4 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

291b599b b784-4bb9-85e0-3c36f0ccc7ad 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

c2e51e1c 81ed-4c8a-b51c-f366b8adaccb 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

6db6bd46 6f7f-4c8d-9240-2aa9f42a0c08 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

8ff5d00c a375-44e4-b937-847815ffe1ee 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.