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
This is a critical need for me. I need it ASAP. :-(
RE: Integrate Powerbi with Pivot tables
I heavily use pivot tables in Excel. Have done for 8 years or so. I have developed an SSAS tabular data warehouse and use it extensively in Excel.
It is so frustrating that those skills are not directly transferable to the Power BI environment.
I can only sort the matrix by the first column of values.
I would love to sort them by a hidden field.
I cant change the column width or word wrap the headings.
I dont have Onedrive for Business so I can just pin the excel features.
RE: Integrate Powerbi with Pivot tables
Please port this kick-ass excel feature over to Power BI.
I've been an excel fan over the years and the pivot is one of the big reasons.
RE: Integrate Powerbi with Pivot tables
I have been using excel powerpivot since 2010. The users love the Pivot Tables. PowerBI is missing that function and I cannot implement it. Will this option coming soon?
RE: Integrate Powerbi with Pivot tables
Pivot tables are the main reason we use Excel. So many great features and freedom in pivot tables. Best self service tool ever. Probably not easy to program in another tool because there are so many options, but it would definitely be the best visualisation ever!
RE: Integrate Powerbi with Pivot tables
I'm really speechless to discover that a tool like power BI doesn't permit to insert a pivot table in their report.
RE: Integrate Powerbi with Pivot tables
We have hundreds if not thousands of pivot tables. We could benefit greatly from power bi if pivot table functionality was available in BI. Now we create dashboards in Excel which is not always easy. Would be great if we could switch to power bi. So much easier to develop dashboards.
RE: Integrate Powerbi with Pivot tables
Power BI is useless to me without a grid that allows dynamic pivoting of dimensions between rows, columns, filters and dynamic drilldown/rollup... Pivot table
RE: Integrate Powerbi with Pivot tables
One of the first things I tried doing as I first started exploring Power BI was to insert a pivot table into Power BI.
RE: Integrate Powerbi with Pivot tables
Pivot table like functionality inside Power BI reports would be incredible and I think is a much needed feature.
The way I view Power BI at the moment is not only providing a better way to visualize data, but a better way to share it too. I'd love to be able to point managers to a Power BI report that updates automatically rather than having to Excel files with Pivot Tables within them.