Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Group by greyed out in Analyze in excel

In the analyze in excel file downloaded from Power BI dashboard, the group button is greyed out in the pivot. Is there any means to enable Group by in pivot of analyze in excel

I tested this with date field, text feild , numeric field and all these have group greyed out

I can confirm that there are no blanks in the column ( calculated column)



Super User IV
Super User IV


Grouping is not allowed on Analyse In Excel connection, you need to do the grouping in the Power BI model, you can add a calculated column with the required grouping logic.


Did I answer your question? Mark my post as a solution! and hit thumbs up

Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors