cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

"Analyze in excel" button

When we use the "Analyze in excel" button then users cannot make a pivot table with count, it does not allow them to drop any non-summed column into the value field, the pivot function will be used a lot. Any comments?

1 ACCEPTED SOLUTION
Burningsuit
Super User
Super User

Hi @Anonymous 

Yes this is working as expected. You can only put measures into the values quadrant of a Pivot Table. Implicit measures (measures created in visualisations) don't count. You'll need to create measures in your Datamodel for users to work with in Analyse in Excel.

Burningsuit_0-1638447651208.png

Burningsuit_1-1638447808572.png

Hope this helps

Stuart

 

 

View solution in original post

2 REPLIES 2
ibarrau
Super User
Super User

Hi. The excel connected to Power Bi Dataset will only allow columns for "Columns and Rows". If you want to use Values in the pivot table you can only drag Measures in there. Adding any column under values for a visualization and make it a Count is a Power Bi Feature that excel won't have. You need to create all measures you think the user might need to help them building pivot tables.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Burningsuit
Super User
Super User

Hi @Anonymous 

Yes this is working as expected. You can only put measures into the values quadrant of a Pivot Table. Implicit measures (measures created in visualisations) don't count. You'll need to create measures in your Datamodel for users to work with in Analyse in Excel.

Burningsuit_0-1638447651208.png

Burningsuit_1-1638447808572.png

Hope this helps

Stuart

 

 

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors