Criar um botão na Caixa de Diálogo Medidas do Excel que permita a Indentação da Função, em Anexo segue os detalhes com imagens ilustrativas para melhor exemplificar.

With the tables, if the header is not visible, Excel displays the headers of the table in the columns headers (see the picture attached)

It will be great to have the same behaviour with the pivot tables

There are times when I need to add a column to a pivot table that just shows the value from the field without calculation. For example, part number and part name. I will setup the the pivot table to summarize by part name, but I need the part number to show up in a column, not as a sub-item of the part name in the first column.

I use pivot tables daily and often have to drill down into the data to understand some additional details or context but one annoying 'feature' is that the date column is never expanded to display the whole date.

Please could this be looked at as it is very frustrating to have to resize the field every singe time I drill down.

Thanks

The show items with no data selection in Pivot field settings is available in Pivots created in the normal manner, however, when creating pivots using the data model this selection is no longer available. The implication is that if no data exists for a certain selection the structure i.e. column headings are removed and I need them to remain. I need to use functionality given in the data model pivot tables and do not expect a trade-off in loss of other functionality.

I use pivot tables daily and often have to drill down into the data to understand some additional details or context but one annoying 'feature' is that the date column is never expanded to display the whole date.

Please could this be looked at as it is very frustrating to have to resize the field every singe time I drill down.

Thanks

I use pivot tables daily and often have to drill down into the data to understand some additional details or context but one annoying 'feature' is that the date column is never expanded to display the whole date.

Please could this be looked at as it is very frustrating to have to resize the field every singe time I drill down.

Thanks

Create a better shortcut for pivot table creation. Currently the shortcut I most use is ALT+N+T to create a table and immediately use ALT+N+V to use that table to create a pivot table. However there was a recent introduction of the need to do ALT+N+V+T. Bad move. Table creation and Pivot table creation deserve more love in the form of a better shortcut.

For Pivot Table Styles, the options are to use an existing Style or Create a new style from scratch.

It would be useful if we could:
- modify an existing Style and give it a new name

In this way, we do not have to re-configure all of the formatting elements from scratch.

It would be helpful to be able to export all DAX and M from Power Pivot / Query. Something like “Script Data Model”, similar to the functionality in SSMS.

I want to reuse code, and I’d rather not have to get all the way into the data model to grab the code.
This could open the door to importing a data models architecture too...

I have pivot tables with % difference from and get error message that I can not sort the table high to low with the calculation. this is a serious limitation that I'm hoping is upgraded.

It is often the case that I have two large tables both with the same unique identifier columns, one as my main table the the other as my lookup table to fetch more information about a certain item. When I try to create a one to one relationship between them power pivot malfunctions and fetches and displays all the rows in the lookup table for every row in the main table. Please fix this!

Power BI has this functionality and it would be great if Power Pivot had it as well.

There is often a LOT of data behind the scenes in a pivot table and so adding this feature would prevent accidentally loading thousands of rows into a single worksheet and slowing down excel.

There must be option of having Grand Total row in the top of pivot table

Pivot Table: Value Field Setting

Show just the value (no stats). Remove "Sum of", "Count of" from pivot tables and charts.
Pivot Tables are Fantastic Tools to quickly filter and display data, but I have to run VBA every time I do a new selection to remove the wording "Sum of..." or what ever the default is...
Please assist
Thank you
John Murray

Can you please increase the maximum limit for characters in a table or column name for data models?

The maximum limit is 100 characters as per this article:

https://support.microsoft.com/en-us/office/data-model-specification-and-limits-19aa79f8-e6e8-45a8-9be2-b58778fd68ef

I would very much like to see a higher limit, say 256 characters.