With all the queries on the internet, we assume there is no built-in option to prevent pivot tables from overwriting data beneath the table during refresh and expansion. Is that correct?

Given that Excel has options for 'inserting' rows, why in the world would Microsoft NOT provide a pivot table expansion/contraction option for inserting or deleting rows from within the refreshed table without overwriting data beneath or to the right of the table?

It is also interesting that inserting rows into a regular Excel table, using the TAB key in the last row, can add rows by expanding the table without overwriting the data beneath. Yet, it will fill in any blank rows first before shifting down the data rows beneath the table.

Given the many requests for this option, we are surprised that Microsoft has not responded to this request.

Incorrect values of dimension in pivot table sourced on OLAP cube (Microsoft SSAS 11.0.5569.0). The latest version without that bug is 16.0.6001.1068. Obviously we don’t know exact source of this bug, but most of the issues we discovered were on complex pivot tables with many attributes, partially displayed dimension’s hierarchy and without subtotals. Example of this bug occurring is in attached file ExcelBug. There are 2 exactly the same pivot tables (the table on the right hand side is basically copy of the table on the left hand side). After removing “Grand Total” on the table on the right hand side some fields have incorrect data displayed.
In this example field B4 contains correct value: „5 Name” (coloured green), field G4 (after removing grand total) contains wrong value: „6 Name” (coloured red).
Video https://youtu.be/RRwfAQVGBfc shows steps to change data source of pivot table and the bug itself. Files ExcelBugSSAS.abf and ExcelBugDBMSSQL.bak are backups of SSAS cube and database with all metadata and data to recreate this scenario in any environment (with SQL Server 2012).

I want to be able to sort various values I have selected in my Pivot table in addition to the rows and columns.

For example, in a pivot table representing code coverage, I have class and function as my rows, for my values I have lines of code and the percentage of code touched. In order to see where I should best focus my efforts, I want to see the functions with the most lines of code and the least code coverage, so I want to sort first by LoC (descending) and then by coverage percentage (ascending).

This doesn't appear to have the votes reflecting it, but this is a very common search. Several examples of this ask (since as early as 2014...):

https://social.technet.microsoft.com/Forums/ie/en-US/10142054-a7a4-4aab-9142-c592f391d0ab/how-to-sort-pivot-table-on-multiple-columns?forum=excel

https://superuser.com/questions/1022547/cannot-sort-excel-pivot-table-by-two-or-more-columns

https://stackoverflow.com/questions/23499203/sorting-excel-pivot-tables-by-multiple-columns

There is also an additional UserVocie request on the Mac version:
https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/35493697-sort-on-multiple-columns-in-a-pivot-table-i-can-n

Can we please get support for this across all versions of excel? This has been a popular ask for quite a while.

It's about time to improve support for SSAS Tabular:
1. Auto-generate DAX
2. Avoid splitting a table into a "measure group" and "dimension". See how PBI Desktop handles metadata.
3. Carry over data types so that users can create reports, such as show me invoices where Due Date is greater than ... Currently, all dimension table fields map to Text.
4. Many customers have expressed interest to connect Excel tables directly to Tabular, bypassing Pivot Table, so they can use the column dropdowns and other Excel goodness.
5. Support descriptions as tooltips when the user hovers on a field in the Field List.

it would be good if when you run a pivot chart based on a pivot table you can drop a column of data from the chart without affecting base table. I use the pivot chart to summarise a number of variables but I want the chart to only show one or two of the variables.

Also when displaying data I like to use more than one pivot table, however you then have to update filters separately. it would be good if filters can be linked on more than one table so that they only need to be updated once. (I use 2 pivot tables to make the data clearer for someone reviewing the data)

I would love an option to add the n value any time I use percentage of total xxxxx in pivot tables. Percentage of what is a very common ask when you pivot table any data and want to display any of the percentage of total options. Currently you need to have one column or row that displays the counts or sum (or whatever variable you are using) and a second column or row to display percent. When what I really want is one column or row with percent but I always need to provide context for percent. Is it 10% of 10 or 1,000,000? So maybe instead of displaying 100% as the total/subtotal we can have that total/subtotal display our n value.

Suppose you have a dashboard filled with charts, each of which could be modified in various ways. For example, you might want to change one chart's...time period, smoothing value, lines that are displayed, data ID, organization, polynomial level, etc.

Today, the only way to do that is to set up individual slicers for each chart. The dashboard I'm working on now requires eight slicers for each of eight charts. This is a lot of work; it's difficult to cram them all onto the screen; and it slows performance.

It would be so much easier if we could use one slicer to choose the figure number or name to which other slicers could link. That way, I could use one set of slicers to adjust any number of charts I could fit into the dashboard.

Note: this behavior is easy to set up with Form Controls, because their links can be redirected by using dynamic range names. Unfortunately, Form Controls are essentially deprecated.

When sending a report to a coworker they usually need it printed. In order to make it easy to use I have to manually add page breaks to keep row sub-fields consolidated to a page (prevent rows from running over to the next page for a field under a higher priority field). It would be great it there was the ability in power pivot to decide which field you would like to use as an automatic page break for either every new group under that field or at the last field-group that would not end up running over to the next page.

With MS Query, I could replace a portion of the SQL code that would be executed with a "parameter" from a cell. I realize this opens up the possibility of code injection, but with proper input validation in Power Query, this should not be an issue. The way parameters are set now in Power Query, there is no way to dynamically get a value from a cell, only to either manually type it in, or get one from another query. There's also no way to pass the manually entered parameter to the SQL code, only to filter on results, which is less efficient as the filter is applied by Power Query rather than by the database.