How to present measures as dimension values

[lewand03]

Hi all,

I am feeding my Power BI with data from SAP BW, and everything is going fine unless I am using source queries with two structures.

In such case Power BI is creating every combination of items in both structure as separate KPI. For example:

Query View:

Power BI View:

Is it possible to convert this view to have CY as a measure and account structure (Gross revenue, discounts, EBIT etc.) present as dimension values?

Thanks.

D.

[v-ljerr-msft]

Hi @lewand03,

Currently we are unable to select the BW Characteristics Attributes to be used in Power BI. Here is a similar idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. 

Regards

[lewand03]

Thanks v-ljerr-msft,

I can vote for that as I missed it as well, but my issue is not related to attributes, but to key Figures and two structures used in BEx query.

Regards,

DL