Pivot Rows To Columns, Columns to Rows for both Attributes and Measures

Angel Torres-Vargas

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

The Villages

Description (Required):

I have not been able to find a way to Pivot Rows To Columns or Columns To Rows through FAW DV, Data Flow, or by creating a dataset.

Pivot Tables feature only allows the values to be measures and not non-aggregated values such as strings.

Use Case and Business Need (Required):

In ERP Projects Module, we have Class Category and Class Code. We frequently pivot this so we have each class category as its own column with the class code as the value in that column.

See attachments for how I do this using Power Query in Excel (Power Query is also available in Power BI).

Pivot Rows to Columns.xlsx

Enhancement Request / Service Request:

Enhance Pivot Table to allow attributes in values section of Grammar Panel or add Pivot Rows to Columns and Columns to Rows feature in data transformation step (e.g. data flow, dataset, semantic modeling).

Below example is from Power Query for Rows to Columns. See attached Excel file for result.