on 14 Jun 2016 00:18:58
The Analyze in Excel feature is an excellent addition to Power BI. For an enhancement, I recommend adding the ability to utilize Excel's standard pivot table functionality of adding implicit measures for numeric fields from source data. This functionality would be similar to the process for creating pivot tables with Power Pivot where custom measures can be used with standard Excel measures in the same pivot table.
The requirement to create custom measures for simple aggregations (i.e. sum of xx numeric field) removes one of the largest advantages of creating summarizations in Excel. It is also difficult for report developers to anticipate all potential aggregations the end user will want to review. Consistent pivot table functionality in Excel is important for this feature since the target audience for results are Excel users.
Administrator on 17 Oct 2022 18:51:06
We are working on this in conjunction with the Excel team
- Comments (14)
RE: Analyze in Excel Standard Pivot Table Aggregations
Yes this would be useful, it would be even more useful to be able to create explicit measures too.
RE: Analyze in Excel Standard Pivot Table Aggregations
Any updates on when this will be implemented? It would be incredibly useful in my daily workflow!
RE: Analyze in Excel Standard Pivot Table Aggregations
This functionality will highly improve the flexibility to do data analysis in Excel, the Power BI tool will be more widely used across the BI industry.
RE: Analyze in Excel Standard Pivot Table Aggregations
This enhancement would really improve our flexibility and efficiency in digging through the data in PBI.
RE: Analyze in Excel Standard Pivot Table Aggregations
Analyze in Excel needs to be able to work with values the same as it does in PBI. Otherwise, the functionality of the tool drops off considerably.
RE: Analyze in Excel Standard Pivot Table Aggregations
Indeed, this feature needs to be enhanced. A large amount of business users who are still used to do Data Analysis through Excel.
RE: Analyze in Excel Standard Pivot Table Aggregations
Great feature enhancement to support the power Excel users.
RE: Analyze in Excel Standard Pivot Table Aggregations
When this idea will be implemented ?
RE: Analyze in Excel Standard Pivot Table Aggregations
Is there any update or workaround for this? Doesn't make sence for me to create from all fields a measure to be able to report in excel. I don't understand why you can add fields as a measure while in excel it doesn't allow you...
RE: Analyze in Excel Standard Pivot Table Aggregations
This idea has been planning for a long time, is there any update on this?