Analyze in Excel: Only Measures as Values?

[Anonymous]

Hey guys,

not sure if I don't understand the pivot table in excel enough, but when I click on analyze in excel, only the measures of my PBI Report are available as values.

I want to work with many different fields of my data, is this only possible to work with them as values if I created measures before?

My data looks like

Project	Country	ID	Investor	Debt	Margin	Equity	... +80
Milka	Germany	01	Peter	12341251	5792	9237593
Lindt	Suisse	02	Luke	3413	434134	13413
Reeses	America	03	Luke	141313	134	41341
...+200

For example, I want my rows to be Country and my columns to be investor; my values debt.

But I can only use debt if I created a measure =SUM(Debt) before.

Is there a different way than creating measure for every single variable?

Thanks for your help,

Greetings,

Janik

[v-zhenbw-msft]

Hi @Anonymous ,

Sorry for that you need to create some measures in Power BI Desktop, the column cannot be used as a value in Excel.

Please refer Can't drag anything to the PivotTable Values area (no measures).

Best regards,

Community Support Team _ zhenbw

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

[Anonymous]

Hey @VilleQvist ,

Thanks for your answer.

What do you mean with Tabular Editor, how do i do this?

[VilleQvist]

Yeah, there are some limitations when using analyzing excel, and one of those are that you can't put anything else than measures in values. It is also best practice to use only measures in values so you should just create those. If there are many of columns, you can always use Tabular Editor or similar to create scripts to do those measures all in once.