Forum Discussion

lewand03's avatar
lewand03
Icon for Helper I rankHelper I
9 years ago

How to present measures as dimension values

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.

Need Help

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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. :smileyhappy:

     

    Regards

    • lewand03's avatar
      lewand03
      Icon for Helper I rankHelper I
      9 years ago

      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