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)
@Jason6 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.
⭕ Subscribe and learn Power BI from these videos ⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!